Concept
If you're scrolling through 50,000 rows, you're working the wrong way. Learn these eight and your speed triples.
Movement
| Shortcut | What it does |
|---|---|
Ctrl + ↓ |
Jump to the last row of data |
Ctrl + ↑ |
Jump to the first row |
Ctrl + → / ← |
Jump to the last / first column |
Ctrl + Home |
Back to A1 |
Ctrl + End |
The last used cell on the sheet |
The rule: Ctrl + arrow takes you to the edge of the data. If the current cell is empty, it goes to the next filled cell. If there's a blank row in the middle of your data, it stops there — which is actually a useful diagnostic for finding blank rows.
Selection — just add Shift
| Shortcut | What it does |
|---|---|
Ctrl + Shift + ↓ |
Select everything from here downward |
Ctrl + Shift + → |
Select everything from here rightward |
Ctrl + Shift + End |
Select from here to the end of the sheet |
Ctrl + A |
Select the data block (press again for the whole sheet) |
Shift + Space |
Select the entire row |
Ctrl + Space |
Select the entire column |
The most-used combination by far is Ctrl + Shift + ↓ — selecting a full column of data. No more dragging the mouse through 50,000 rows.
Between sheets
| Shortcut | What it does |
|---|---|
Ctrl + Page Down |
Next sheet |
Ctrl + Page Up |
Previous sheet |
The one nobody knows
Ctrl + Backspace — if you've scrolled far away and your active cell is off-screen, this snaps you straight back to it. A lifesaver on large sheets.
And F5 → Special → Blanks, which selects every empty cell at once. Type something and press Ctrl + Enter to fill them all together. You'll use this constantly in data cleaning (detailed in M6).
[SS-4: Go To Special dialog with Blanks option highlighted]
A warning:
Ctrl + Endsometimes takes you somewhere absurd likeXFD1048576when your data is only 100 rows. That means something was there once — formatting, or deleted data — and Excel still considers it "used". Fix it by selecting the extra rows and columns and deleting them (delete, not clear), then save and reopen the file. Your file size will drop too.