Are you tired of navigating through endless menus and toolbars in Microsoft Excel? Do you want to save time and increase your efficiency while working with spreadsheets? Look no further! Our comprehensive Excel Shortcut Cheat Sheet is here to revolutionize your Excel experience and boost your productivity to new heights.
To help you get started, we’ve compiled a detailed cheat sheet of the most useful Excel shortcuts. Bookmark this page and refer to it whenever you need to speed up your Excel tasks.
Excel Shortcut Cheat Sheet
| Shortcut | Description | Category |
|---|---|---|
| F1 | Displays the Office Assistant or (Help > Microsoft Excel Help) | Miscellaneous |
| F2 | Edits the active cell, putting the cursor at the end | Editing |
| F3 | Displays the (Insert > Name > Paste) dialog box | Editing |
| F4 | Repeats the last worksheet action (Edit > Repeat) | Editing |
| F5 | Displays the (Edit > GoTo) dialog box | Navigation |
| F6 | Moves to the next pane in a workbook (if the window is split) | Navigation |
| F7 | Displays the (Tools > Spelling) dialog box | Miscellaneous |
| F8 | Toggles whether to extend a selection with the arrow keys | Editing |
| F9 | Calculates All the worksheets in All the open workbooks | Formulas and Functions |
| F10 | Toggles the activation of the Menu Bar | Miscellaneous |
| F11 | Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range | Charts and Graphics |
| F12 | Displays the (File > Save As) dialog box | File |
| Shift + F2 | Inserts or edits a cell comment (Insert > Comment) | Editing |
| Shift + F3 | Displays the (Insert > Function) dialog box | Formulas and Functions |
| Shift + F4 | Repeats the last Find, the same as (Edit > Find Next) | Editing |
| Shift + F5 | Displays the (Edit > Find) dialog box | Editing |
| Shift + F6 | Moves to the previous pane in a workbook (if the window is split) | Navigation |
| Shift + F8 | Toggles between switching Add Mode on or off* | Editing |
| Shift + F9 | Calculates just the active worksheet | Formulas and Functions |
| Shift + F10 | Displays the (Shortcut) menu for the selected item | Miscellaneous |
| Shift + F11 | Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) | File |
| Shift + F12 | Saves, Displays the (File > Save As) dialog box if a new workbook | File |
| Ctrl + F1 | Closes and reopens the current task pane (ribbon in 2007) | Miscellaneous |
| Ctrl + F2 | Print Preview | File |
| Ctrl + F3 | Displays the (Insert > Name > Define) dialog box | Formulas and Functions |
| Ctrl + F4 | Closes the selected workbook window | File |
| Ctrl + F5 | Restores the size of the active workbook or window | Miscellaneous |
| Ctrl + F6 | Moves to the next open workbook or window | Navigation |
| Ctrl + F7 | Activates the Move window command | Miscellaneous |
| Ctrl + F8 | Activates the Resize window command | Miscellaneous |
| Ctrl + F9 | Minimises the size of the active workbook or window | Miscellaneous |
| Ctrl + F10 | Maximises the size of the active workbook or window | Miscellaneous |
| Ctrl + F12 | Displays the (File > Open) dialog box | File |
| Alt + F1 | Creates a chart (on a chart sheet) using the highlighted range | Charts and Graphics |
| Alt + F2 | Displays the (File > Save As) dialog box | File |
| Alt + F4 | Closes all the workbooks (saving first) and exits Excel (File > Exit) | File |
| Alt + F8 | Displays the (Tools > Macro > Macros) dialog box | Miscellaneous |
| Alt + F11 | Toggles between the Visual Basic Editor window and and the Excel window | Miscellaneous |
| Alt + Ctrl + F9 | Calculates All cells on All worksheets in All workbooks | Formulas and Functions |
| Alt + Shift + F1 | Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) | File |
| Alt + Shift + F2 | Displays the (File > Save As) dialog box | File |
| Alt + Shift + F4 | Closes all the workbooks (saving first) and exits Excel (File > Exit) | File |
| Alt + Shift + F10 | Displays the drop-down menu for the corresponding smart tag | Miscellaneous |
| Alt + Shift + F11 | Activates the Microsoft Script Editor window | Miscellaneous |
| Ctrl + Shift + F3 | Displays the (Insert > Name > Create) dialog box | Formulas and Functions |
| Ctrl + Shift + F6 | Moves to the previous open workbook or window | Navigation |
| Ctrl + Shift + F10 | Activates the Menu Bar or Shortcut Characters in 2007 | Miscellaneous |
| Ctrl + Shift + F12 | Displays the (File > Print) dialog box | File |
| Ctrl + 0 | Hides the columns in the current selection | Miscellaneous |
| Ctrl + 1 | Displays the formatting dialog box | Formatting |
| Ctrl + 2 | Toggles bold on the current selection | Formatting |
| Ctrl + 3 | Toggles italics on the current selection | Formatting |
| Ctrl + 4 | Toggles underlining on the current selection | Formatting |
| Ctrl + 5 | Toggles the strikethrough of text on the current selection | Formatting |
| Ctrl + 6 | Toggles between hiding, displaying | Miscellaneous |
| Ctrl + 8 | Toggles the display of Outline symbols on the active worksheet | Miscellaneous |
| Ctrl + 9 | Hides the rows in the current selection (Format > Row > Hide) | Miscellaneous |
| Ctrl + Shift + 0 | Unhides the columns in the current selection | Miscellaneous |
| Ctrl + Shift + 2 | Enters the value from the cell directly above into the active cell | Editing |
| Ctrl + Shift + 8 | Selects the current region (surrounded by blank rows and columns) | Editing |
| Ctrl + Shift + 9 | Unhides the rows in the current selection | Miscellaneous |
| Ctrl + A | Displays formula palette given a function name or selects the whole worksheet or current date | Formulas and Functions |
| Ctrl + B | Toggles bold on the current selection | Formatting |
| Ctrl + C | Copies the current selection to the clipboard | Editing |
| Ctrl + D | Copies the first cell in the selection downwards | Editing |
| Ctrl + F | Displays the Find dialog box | Editing |
| Ctrl + G | Displays the GoTo dialog box | Navigation |
| Ctrl + H | Displays the Replace dialog box | Editing |
| Ctrl + I | Toggles italics on the current selection | Formatting |
| Ctrl + K | Displays the Insert Hyperlink dialog box | Miscellaneous |
| Ctrl + L | Displays the Create Table dialog box | Data |
| Ctrl + N | Creates a new workbook | File |
| Ctrl + O | Displays the Open dialog box | File |
| Ctrl + P | Displays the Print dialog box | File |
| Ctrl + R | Copies the leftmost cell in the selection to the right | Editing |
| Ctrl + S | Saves, Displays the Save As dialog box if a new workbook | File |
| Ctrl + U | Toggles underlining on the current selection | Formatting |
| Ctrl + V | Pastes the entry from the clipboard | Editing |
| Ctrl + W | Closes the active workbook or window | File |
| Ctrl + X | Cuts the current selection to the clipboard | Editing |
| Ctrl + Y | Repeats the last workbook action | Editing |
| Ctrl + Z | Undo the last workbook action | Editing |
| Ctrl + Shift + F | Activates the Font Tab of the format cells | Formatting |
| Ctrl + Shift + O | Selects all the cells with comments | Editing |
| Ctrl + Shift + P | Activates the Font Size tab of the format cells | Formatting |
| Enter | Enters the contents of the active cell and moves to the cell below (by default) | Editing |
| Shift + Enter | Enters the contents of the active cell and moves to the cell above (by default) | Editing |
| Tab | Enters the contents of the active cell and moves one cell to the right | Editing |
| Shift + Tab | Enters the contents of the active cell and moves one cell to the left | Editing |
| Alt + = | Enters the SUM() function (AutoSum) to sum the adjacent block of cells | Formulas and Functions |
| Alt + 0128 | Enters the euro symbol (€) (using Number keypad) | Miscellaneous |
| Alt + 0162 | Enters the cent symbol (¢) (using Number keypad) | Miscellaneous |
| Alt + 0163 | Enters the pound sign symbol (£) (using Number keypad) | Miscellaneous |
| Alt + Enter | Enters a new line (or carriage return) into a cell | Editing |
| Ctrl + ‘ | Enters the contents from the cell directly above into the active cell | Editing |
| Ctrl + Shift + 2 | Enters the value from the cell directly above into the active cell | Editing |
| Ctrl + ; | Enters the current date into the active cell | Editing |
| Ctrl + Shift + ; | Enters the current time into the active cell | Editing |
| Ctrl + Shift + Enter | Enters the formula as an Array Formula | Formulas and Functions |
| Shift + Insert | Enters the data from the clipboard | Editing |
| Alt + Down Arrow | Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original contents | Editing |
| Delete | Deletes the selection or one character to the right | Editing |
| Backspace | Deletes the selection or one character to the left Shift + Delete Cuts the selection to the clipboard | Editing |
| Ctrl + Delete | Deletes text to the end of the line | Editing |
| Ctrl + – | Displays the Delete dialog box | Editing |
| Ctrl + Shift + = | Displays the Cells dialog box | Editing |
| Ctrl + | Selects the cells in a selected row that do not match the value in the active cell | Editing |
| Ctrl + Shift + | Selects the cells in a selected column that do not match the value in the active cell | Editing |
| Ctrl + / | Selects the array containing the active cell ?? | Editing |
| Alt + ; | Selects the visible cells in the current selection | Editing |
| Ctrl + Shift + (8 or *) | Selects the current region (surrounded by blank rows and columns) | Editing |
| Ctrl + | Selects the current region (using the * on the number keyboard) | Editing |
| Ctrl + [ | Selects all the cells that are directly referred to by the formula in the active cell (precedents) | Formulas and Functions |
| Ctrl + Shift + [ | Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell | Formulas and Functions |
| Ctrl + ] | Selects all the cells that directly refer to the active cell (dependents) | Formulas and Functions |
| Ctrl + Shift + ] | Selects all the cells that directly (or indirectly) refer to the active cell | Formulas and Functions |
| Ctrl + Shift + Page Down | Selects the active worksheet and the one after it | Navigation |
| Ctrl + Shift + Page Up | Selects the active worksheet and the one before it | Navigation |
| Ctrl + Shift + Spacebar | Selects all the objects on the worksheet when an object is selected or selects the whole worksheet | Editing |
| Ctrl + Spacebar | Selects the current column | Editing |
| Shift + Arrow keys | Selects the active cell and the cell in the given direction | Editing |
| Shift + Backspace | Selects the active cell when multiple cells are selected | Editing |
| Shift + Spacebar | Selects the current row | Editing |
| Ctrl + Shift + Arrow Key | Extends the selection to the next cell adjacent to a blank cell in that direction | Editing |
| Ctrl + Shift + End | Extends the selection to the last used cell on the worksheet | Editing |
| Ctrl + Shift + Home | Extends the selection to the beginning of the worksheet | Editing |
| Shift + Arrow Keys | Extends the selection by one cell in that direction | Editing |
| Shift + Home | Extends the selection to the first column | Editing |
| Shift + Page Down | Extends the selection down one screen | Editing |
| Shift + Page Up | Extends the selection up one screen | Editing |
| End + Shift + Arrow Keys | Extends the selection to the next non-blank cell in that direction | Editing |
| End + Shift + End | Extends the selection to the last cell in the current row | Editing |
| End + Shift + Home | Extends the selection to last used cell on the worksheet | Editing |
| Alt + ‘ | Displays the Style dialog box | Formatting |
| Ctrl + Shift + ( ‘ or ) | Applies the Time format “hh:mm” to the selection | Formatting |
| Ctrl + Shift + (1 or !) | Applies the Comma separated format “#,##0.00” to the selection | Formatting |
| Ctrl + Shift + (4 or $) | Applies the Currency format “£#,##0.00” to the selection | Formatting |
| Ctrl + Shift + (5 or %) | Applies the Percentage format “0%” to the selection | Formatting |
| Ctrl + Shift + (6 or ^) | Applies the Exponential format “#,##E+02” to the selection | Formatting |
| Ctrl + Shift + (# or ~) | Applies the General format to the selection | Formatting |
| Ctrl + (# or ~) | Applies the Custom Date format “dd-mmm-yy” to the selection | Formatting |
| Ctrl + Shift + (7 or &) | Applies the outline border to the selection | Formatting |
| Ctrl + Shift + (- or _ ) | Removes all the borders from the selection | Formatting |
| Arrow Keys | Moves to the next cell in that direction | Navigation |
| Ctrl + Tab | Moves to the next open workbook or window | Navigation |
| Alt + Tab | Moves to the next application open on your computer | Navigation |
| Alt + Shift + Tab | Moves to the previous application open on your computer | Navigation |
| Enter | Moves to the cell directly below | Navigation |
| Tab | Moves to the next cell on the right (or unprotected cell) | Navigation |
| Home | Moves to the first column in the current row | Navigation |
| End + Arrow Keys | Moves to the next non empty cell in that direction | Navigation |
| End + Enter | Moves to the last cell in the current row that is not blank | Navigation |
| End + Home | Moves to the last used cell on the active worksheet* | Navigation |
| End + Home | Moves to the last used cell on the active worksheet* | Navigation |
| Page Down | Moves to the next screen of rows down | Navigation |
| Page Up | Moves to the previous screen of rows up | Navigation |
| Shift + Enter | Moves to the cell directly above (opposite direction to Enter) | Navigation |
| Shift + Tab | Moves to the cell directly to the left (opposite direction to Tab) | Navigation |
| Alt + Page Down | Moves you one screen of columns to the right | Navigation |
| Alt + Page Up | Moves you one screen of columns to the left | Navigation |
| Ctrl + Home | Moves to cell “A1” on the active sheet | Navigation |
| Ctrl + End | Moves to the last used cell on the active worksheet* | Navigation |
| Ctrl + Up Arrow | Moves to the first row in the current region | Navigation |
| Ctrl + Down Arrow | Moves to the last row in the current region | Navigation |
| Ctrl + Left Arrow | Moves to the first column in the current region | Navigation |
| Ctrl + Right Arrow | Moves to the last column in the current region | Navigation |
| Ctrl + Page Up | Moves to the previous worksheet in the workbook | Navigation |
| Ctrl + Page Down | Moves to the next worksheet in the workbook | Navigation |
| Ctrl + Shift + Tab | Moves to the previous open workbook or window | Navigation |
| Scroll Lock + Arrow Keys | Moves the workbook or window one cell the corresponding direction | Navigation |
| Scroll Lock + End | Moves to the last cell in the current window | Navigation |
| Scroll Lock + Home | Moves to the first cell in the current window | Navigation |
| Scroll Lock + Page Down | Moves you down one screen (current selection unchanged | Navigation |
| Scroll Lock + Page Up | Moves you up one screen (current selection unchanged) | Navigation |
| Enter | Moves from top to bottom within a selection | Navigation |
| Tab | Moves from left to right within a selection | Navigation |
| Ctrl + . | Moves clockwise to the next corner within a selection | Navigation |
| Shift + Tab | Moves from right to left within a selection (opposite direction to Tab) | Navigation |
| Alt + Ctrl + Left Arrow | Moves to the left between non adjacent cells in a selection | Navigation |
| Alt + Ctrl + Right Arrow | Moves to the right between non adjacent cells in a selection | Navigation |
| = | Starts a Formula | Formulas and Functions |
| Ctrl + ` | Toggles between the value layer and the formula layer | Formulas and Functions |
| Ctrl + Insert | Copies the current selection to the clipboard | Editing |
| Ctrl + Shift + ( | Unhides any hidden rows within the selection | Miscellaneous |
| Ctrl + Shift + ) | Unhides any hidden columns within the selection | Miscellaneous |
| Ctrl + Shift + \ | Select unequal cells | Editing |
Why Use Our Free Excel Shortcut Cheat Sheet?
Our Free Interactive Excel Shortcut Cheat Sheet is the ultimate resource for mastering keyboard shortcuts in Excel. Here’s why:
- Comprehensive Collection: We have meticulously compiled an extensive list of Excel shortcuts, covering every aspect of working with spreadsheets. From basic navigation and formatting to advanced functions and data manipulation, our cheatsheet has it all. You’ll find shortcuts for both Windows and Mac versions of Excel, ensuring compatibility across platforms.
- Easy to Use and Navigate: Our cheat sheet is designed with user-friendliness in mind. The shortcuts are organized into intuitive categories, making it effortless to find the one you need. Whether you’re a beginner or an experienced Excel user, you’ll be able to quickly locate and apply the relevant shortcuts to your workflow.
- Boost Your Productivity: By incorporating Excel keyboard shortcuts into your daily routine, you’ll experience a significant boost in productivity. Shortcuts allow you to perform tasks faster, reduce repetitive strain on your mouse hand, and streamline your workflow. With our cheatsheet, you’ll be amazed at how much time you can save and how efficiently you can work with Excel.
- Suitable for All Skill Levels: Whether you’re an Excel novice or a seasoned pro, our Excel Shortcut Cheatsheet caters to all skill levels. Beginners can start by mastering the essential shortcuts for navigation and formatting, while advanced users can dive into more complex shortcuts for data analysis and automation. The cheatsheet grows with you as you expand your Excel skills.
Feel free to contact me through the contact page if you want me to add other useful excel shortcuts to this already comprehensive list!