Keyboard short-cuts can make life much easier when using Excel… You may already have your favourites and use them all the time but here is a list of them all.
F1 | Display Excel Help |
CTRL+F1 | Display or hide the ribbon |
ALT+F1 | Create a chart using selected data range |
ALT+SHIFT+F1 | Insert new worksheet |
F2 | Edit active cell with cursor placed at the end of the cell’s contents |
SHIFT+F2 | Add or Edit a comment |
CTRL+F2 | Display Print Preview |
F3 | Display Paste Name dialog box if there are any |
SHIFT+F3 | Display Insert Function dialog box |
F4 | Repeat last command |
CTRL+F4 | Close selected workbook window |
ALT+F4 | Close Excel |
F5 | Display GoTo dialog box |
CTRL+F5 | Restore the window size of the selected workbook window |
F6 | Switch between worksheet, ribbon, task pane, and Zoom controls |
CTRL+F6 | Switch to the next workbook window |
F7 | Display the Spelling dialog box to check spelling in the active worksheet or selected range |
CTRL+F7 | Move the workbook window when it is not maximized using the arrow keys before pressing ENTER to finish or ESC to cancel |
F8 | Extend the current selection using the arrow keys |
SHIFT+F8 | Add a non-adjacent cell or range to a selection of cells using the arrow keys |
CTRL+F8 | Resize a window that is not maximised using the arrow keys |
ALT+F8 | Display the Macro dialog box to create, run, edit or delete a macro |
F9 | Calculate all worksheets in all open workbooks |
SHIFT+F9 | Calculate Active Worksheet |
CTRL+ALT+F9 | Calculate all worksheets in all open workbooks |
CTRL+ALT+SHIFT+F9 | Recheck dependent formulas then calculate all cells in all open workbooks |
CTRL+F9 | Minimise a workbook window to an icon |
F10 or ALT | Toggles key tips on or off |
SHIFT+F10 | Display shortcut menu for a selected item |
ALT+SHIFT+F10 | Display the menu or message for an Error Checking button |
CTRL+F10 | Maximize or restore the selected workbook window |
F11 | Creates a chart using the currently selected data |
SHIFT+F11 | Insert New Worksheet |
ALT+F11 | Open VBA Editor |
F12 | Save As |
CTRL+PgUp | Switch to next worksheet to the right |
CTRL+PgDn | Switch to next worksheet to the left |
CTRL+SHIFT+( | Unhide hidden rows within selection |
CTRL+SHIFT+& | Apply outline border to the selected cells |
CTRL+SHIFT_ | Remove outline border from the selected cells |
CTRL+SHIFT+~ | Apply General number format |
CTRL+SHIFT+$ | Apply Currency format with two decimal places (negative numbers have parentheses) |
CTRL+SHIFT+% | Apply Percentage format with no decimal places |
CTRL+SHIFT+^ | Apply Scientific number format with two decimal places |
CTRL+SHIFT+# | Apply Date format (day, month, and year) |
CTRL+SHIFT+@ | Apply Time format (hour and minute, and AM or PM) |
CTRL+SHIFT+! | Apply Number format with two decimal places, thousands separator, and minus sign (-) for negative values |
CTRL+SHIFT+* | Select the current region around the active cell (the data area enclosed by blank rows and blank columns or an entire PivotTable report |
CTRL+SHIFT+: | Enter current time into the cell |
CTRL+SHIFT+” | Copy value from the cell above the active cell into the cell or the Formula Bar |
CTRL+SHIFT+Plus (+) | Display the Insert dialog box to insert blank cells |
CTRL+Minus (-) | Display the Delete dialog box to delete the selected cells |
CTRL+; | Enter the current date into the selected cell |
ALT+; | Selects visible cells only within the current selection |
CTRL+` | Alternate between displaying cell values and displaying formulas |
CTRL+’ | Copy a formula from the cell above the active cell into the cell or the Formula Bar |
CTRL+1 | Display Format Cells dialog box |
CTRL+2 or CTRL+B | Apply or remove bold formatting |
CTRL+3 or CTRL+I | Apply or remove italic formatting |
CTRL+4 or CTRL+U | Apply or remove underlining |
CTRL+5 | Apply or remove strikethrough |
CTRL+6 | Alternate between hiding and displaying objects |
CTRL+8 | Display or hide the outline symbols |
CTRL+9 | Hide selected rows |
CTRL+0 | Hide selected columns |
CTRL+A | Select the current region. Pressing CTRL+A a second time or if there is no data selects the entire worksheet |
CTRL+C | Copy selected cells |
CTRL+D | Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below |
CTRL+F or SHIFT+F5 | Display Find and Replace dialog box, with the Find tab selected. |
CTRL+SHIFT+F | Open Format Cells dialog box with the Font tab selected. |
SHIFT+F4 | Repeat last Find action |
CTRL+H | DisplayFind and Replace dialog box, with the Replace tab selected |
CTRL+G or F5 | Display Go To dialog box |
CTRL+K | Display the Insert or Edit Hyperlink dialog box |
CTRL+L | Display the Create Table dialog box |
CTRL+N | Create a new blank workbook |
CTRL+O | Display Open dialog box to open or find a file |
CTRL+SHIFT+O | Select all cells that contain comments |
CTRL+P | Display the Print tab |
CTRL+SHIFT+P | Open Format Cells dialog box with the Font tab selected |
CTRL+R | Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right |
CTRL+S | Save the active file with its current file name, location, and file format |
CTRL+T | Display Create Table dialog box |
CTRL+SHIFT+U | Switch between expanding and collapsing of the formula bar |
CTRL+V | Paste contents of the Clipboard after either copying or cuttingCTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. |
CTRL+W | Close the selected workbook window |
CTRL+X | Cut the selected cells |
CTRL+Y | Repeat the last command or action, if possible |
CTRL+Z | Undo the last command or to delete last typed entry |
CTRL+BACKSPACE | Navigate to your selected cell if it is out of view |