| Navigation | |
| Shift+Enter | Move up through a selection |
| Ctrl+↑ | Jump to the top of a column |
| Ctrl+↓ | Jump to the bottom of a column |
| Ctrl+. | Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke) |
| Ctrl+w | Close the active workbook window |
| Ctrl+Shift+F6 | Switch to previous workbook window |
| Ctrl+Tab | Switch to the next open worksheet |
| Ctrl+Shift+Tab | Switch to the previous open worksheet (Mac) |
| F11 | Start a new chart sheet |
| Shift+F11 | Insert a new sheet |
| Ctrl+y | Repeat the last action |
| Ctrl+d | Fill selected cell with the content in the cell above selected cell |
| Ctrl+r | Fill selected cell with the content in the cell to the left of selected cell |
| Formatting | |
| Ctrl+F | Find and replace values |
| Ctrl+Shift+% | Show all values as percentages |
| Ctrl+Shift+$ | Show all values as currency (Note: Replace $ with your own country’s currency key) |
| Ctrl+Shift+~ | Show all values in general number format |
| Ctrl+Shift+& | Apply an outline border to selected cells |
| Ctrl+2 | Apply or remove bold formatting to selected cells |
| Ctrl+3 | Apply or remove italic formatting to selected cells |
| Ctrl+9 | Hide selected rows |
| Ctrl+Shift+( | Unhide selected rows |
| Ctrl+0 | Hide selected columns |
| Ctrl+Shift+) | Unhide selected columns |
| Ctrl+; | Insert current date |
| Ctrl+Shift+: | Insert current time |
| Ctrl+k | Insert a hyperlink |
| Selecting Rows & Columns | |
| Shift+↑ Shift+↓ | Expand the selection by one cell either upward (↑) or downward (↓) |
| Ctrl+Shift+ArrowKey | Expand the selection to the last non-empty cell |
| Ctrl+[spacebar] | Select entire column |
| Shift+[spacebar] | Select entire row |
| Ctrl+a | Select entire sheet |
| Alt+; | Select only the visible cells in the current selection |
| Formulas | |
| = | Start a formula |
| Alt+= | Insert AutoSum formula |
| F2 | Edit Active Cell |
| Ctrl+a | Display the Formula Builder after you type a valid function name in a formula |
| Miscellaneous | |
| F7 | Open spelling & grammar check |
| Shift+F2 | Insert a comment |
Last Edit: 11/12/17 by Juan Osborne