These are the shortcuts you’ll use more than any others in Excel — not formatting, not formulas, just getting around a sheet and selecting the right cells without touching the mouse. Master this handful and everything else in Excel gets faster, because you’re no longer losing your place every time you scroll.
Looking for the full reference instead? See the complete Excel keyboard shortcuts list. Want to actually drill these into muscle memory? Try the trainer right here:
*Recommended browser: Google Chrome
This is currently saved only in this browser. Log in to save it to your account and view it from other devices.
The one pattern that explains most of these
Ctrl+Arrow jumps to the edge of the current block of data — the last cell before an empty one. Ctrl+Shift+Arrow does the exact same jump, except it selects everything along the way instead of just moving the cursor. Once that clicks, you don’t need to memorize navigation and selection as two separate skill sets — selection is just navigation with Shift held down.
| Action | Windows | Mac |
|---|---|---|
| Move to right cell | Tab | Tab |
| Move to left cell | Shift + Tab | Shift + Tab |
| Move to the first row in the current data area | Ctrl + ↑ | Cmd + ↑ |
| Move to the leftmost column in the current data area | Ctrl + ← | Cmd + ← |
| Move to the last row in the current data area | Ctrl + ↓ | Cmd + ↓ |
| Move to the rightmost column in the current data area | Ctrl + → | Cmd + → |
Selecting as you move
Add Shift to any of the navigation shortcuts above and the selection extends with you. These also work without Ctrl, for extending one cell at a time.
| Action | Windows | Mac |
|---|---|---|
| Select the cell below | Enter | Enter |
| Select the cell above | Shift + Enter | Shift + Enter |
| Extend selection up one cell | Shift + ↑ | Shift + ↑ |
| Extend selection right one cell | Shift + → | Shift + → |
| Extend selection down one cell | Shift + ↓ | Shift + ↓ |
| Extend selection left one cell | Shift + ← | Shift + ← |
| Extend selection to the first row in the current data area | Ctrl + Shift + ↑ | Cmd + Shift + ↑ |
| Extend selection to the leftmost column in the current data area | Ctrl + Shift + ← | Cmd + Shift + ← |
| Extend selection to the last row in the current data area | Ctrl + Shift + ↓ | Cmd + Shift + ↓ |
| Extend selection to the rightmost column in the current data area | Ctrl + Shift + → | Cmd + Shift + → |
Selecting and working with whole rows and columns
These build on the same Space-bar pattern: Ctrl+Space selects the whole column, Shift+Space selects the whole row — then whatever you press next (delete, insert, hide) acts on the entire row or column instead of one cell.
| Action | Windows | Mac |
|---|---|---|
| Select the entire column | Ctrl + Space | Ctrl + Space |
| Select the entire row | Shift + Space | Shift + Space |
| Hide the selected row | Ctrl + 9 | Cmd + 9 |
| Hide the selected column | Ctrl + 0 | Cmd + 0 |
| [With a row/column selected] Insert a blank one | Ctrl + Shift + + | Cmd + Shift + ; |
| [With a row/column selected] Delete it | Ctrl + – | Cmd + – |
| Group rows/columns | Alt + Shift + → | Alt + Shift + → |
| Ungroup rows/columns | Alt + Shift + ← | Alt + Shift + ← |
Why this cluster is worth mastering first
Formatting shortcuts save you a click here and there. Navigation shortcuts save you from the single biggest time sink in Excel: scrolling to find where you are, then scrolling back. If you only have five minutes to practice, spend them on Ctrl+Arrow and Ctrl+Shift+Arrow — see how to memorize Excel shortcuts faster for a week-long routine built around exactly this kind of prioritization.