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 |