docs / articles / Master Excel: Complete List of Keyboard Shortcuts

Master Excel: Complete List of Keyboard Shortcuts

Sara Jul 09, 2026 2026-07-09 04:40:45

Excel, a staple in the world of data management, offers a plethora of shortcut keys designed to boost productivity and streamline workflows. Mastering these keyboard commands can significantly enhance your efficiency, allowing you to navigate and manipulate spreadsheets with ease. Let's delve into the comprehensive world of Excel shortcut keys, categorized for your convenience.

Computer tricks😉
Computer tricks😉

Before we dive in, remember that most of these shortcuts are case-insensitive and work across Windows, Mac, and other platforms. For Mac users, simply replace the 'Ctrl' key with 'Cmd' in the listed shortcuts. Now, let's explore the vast landscape of Excel shortcuts, starting with the basics.

Excel shortcut key
Excel shortcut key

Navigation Shortcuts

Navigating Excel sheets can be a breeze with these essential shortcuts.

Excel short cut keys
Excel short cut keys

First, let's discuss the 'Ctrl + Arrow Keys' (or 'Cmd + Arrow Keys' on Mac) combination. This allows you to jump from cell to cell, making it easy to move through your data. To select a range of cells, hold down the 'Shift' key while using the arrow keys.

Moving Between Worksheets

MS Excel shortcut
MS Excel shortcut

To switch between worksheets, use 'Ctrl + Page Up' (or 'Cmd + Page Up') to move to the previous sheet and 'Ctrl + Page Down' (or 'Cmd + Page Down') to move to the next. Alternatively, you can press 'Ctrl + Tab' (or 'Cmd + Tab') to cycle through open workbooks.

For direct access, press 'Ctrl + F2' (or 'Cmd + F2') to open the 'Go To' dialog box, then enter the worksheet name and press 'Enter'.

Zooming and Viewing

short computer keys
short computer keys

Adjust the zoom level with 'Ctrl + Mouse Wheel' (or 'Cmd + Mouse Wheel' on Mac) or use 'Ctrl + -' (or 'Cmd + -') to zoom out and 'Ctrl + +' (or 'Cmd + +') to zoom in. To reset the zoom, press 'Ctrl + 0' (or 'Cmd + 0').

To toggle between different views, use 'Ctrl + 1' for Normal view, 'Ctrl + 2' for Page Layout view, and 'Ctrl + 3' for Page Break preview.

Editing and Formatting Shortcuts

Microsoft Excel Shortcut key
Microsoft Excel Shortcut key

Excel offers numerous shortcuts to help you edit and format your data efficiently.

To copy a cell or range, press 'Ctrl + C' (or 'Cmd + C'), then paste it using 'Ctrl + V' (or 'Cmd + V'). To cut a cell or range, use 'Ctrl + X' (or 'Cmd + X') instead. To copy the format of a cell without its content, use 'Ctrl + Shift + V' (or 'Cmd + Shift + V').

Excel Keyboard shortcuts Keys
Excel Keyboard shortcuts Keys
20 Advanced Excel Shortcut Keys Every Professional Should Know | Excel Productivity Cheat Sheet
20 Advanced Excel Shortcut Keys Every Professional Should Know | Excel Productivity Cheat Sheet
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white
Microsoft Office shortcut
Microsoft Office shortcut
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
8 Advanced Microsoft Excel Shortcut Keys Every Professional Should Know | Excel Productivity Tips
8 Advanced Microsoft Excel Shortcut Keys Every Professional Should Know | Excel Productivity Tips
COMPUTER
COMPUTER
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
20 Excel Shortcut Keys 🔥
20 Excel Shortcut Keys 🔥
excel shortcuts quick reference worksheet is shown in the above text box
excel shortcuts quick reference worksheet is shown in the above text box
the top 50 excel shortcut keys for each player in the game, including an additional number
the top 50 excel shortcut keys for each player in the game, including an additional number
Excel shortcut keys
Excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
Advanced Excel Shortcut keys
Advanced Excel Shortcut keys
Top 10 excel shortcut keys every fresher should know
Top 10 excel shortcut keys every fresher should know
COMPUTER KEYBOARD SHORTCUT KEYS
COMPUTER KEYBOARD SHORTCUT KEYS

Formatting Text

Change the font of selected text with 'Ctrl + 1' (or 'Cmd + 1') to open the 'Format Cells' dialog box. To bold, italicize, or underline text, use 'Ctrl + B', 'Ctrl + I', and 'Ctrl + U' respectively. To align text, use 'Ctrl + L' for left alignment, 'Ctrl + R' for right alignment, and 'Ctrl + E' for center alignment.

To apply number formatting, select the cells, then press 'Ctrl + 1'. In the 'Number' tab, choose the desired format. To apply currency formatting, press 'Ctrl + Shift + $'.

Merging and Centering Cells

To merge cells, select the range, then press 'Ctrl + M'. To center the merged cells horizontally and vertically, press 'Ctrl + 1', then in the 'Alignment' tab, click on the 'Merge and Center' button.

To unmerge cells, select the merged range, then press 'Ctrl + Shift + U'.

Data Manipulation Shortcuts

Excel provides various shortcuts to manipulate and analyze data effectively.

To sort data, select the range, then press 'Ctrl + S'. In the 'Sort' dialog box, choose the desired sort order. To filter data, select the header row, then press 'Ctrl + Shift + L'. Click on the dropdown arrow in the header cell to apply filters.

AutoFill and Flash Fill

To AutoFill a range, drag the fill handle (small square in the bottom-right corner of the selected cell) over the desired range. Excel will automatically fill in the data based on the pattern in the original range.

Flash Fill, introduced in Excel 2013, automatically recognizes patterns in your data and fills in the corresponding values. To use Flash Fill, enter the first few values in a new column, then press 'Ctrl + E'. Excel will attempt to fill in the rest of the column based on the pattern it detects.

Remove Duplicates and Remove Errors

To remove duplicates from a range, select the data, then press 'Ctrl + R'. In the 'Remove Duplicates' dialog box, select the columns to consider when removing duplicates and click 'OK'.

To remove errors from a range, press 'Ctrl + -' (or 'Cmd + -') to display the error cells, then press 'Ctrl + Shift + E' to remove them.

Mastering these Excel shortcuts can significantly enhance your productivity and streamline your workflow. As you become more familiar with these keyboard commands, you'll find yourself navigating and manipulating spreadsheets with ease. So, go ahead, give these shortcuts a try, and watch your Excel skills soar!