Excel like a finance pro.
← The libraryPractice · 2 questions →
Selection shortcut
Extend the selection to A1
Ctrl + Shift + Home on Windows, Fn + Ctrl + Shift + ← on Mac.
OccasionalDifficulty 1000 · Capable
When to use it
Extends the selection from the active cell back to A1.
The shape of it
- Windows
Ctrl + Shift + Home
- Mac
Fn + Ctrl + Shift + ←
Worked examples
Select back to the start
Click the last data cell, press Ctrl + Shift + Home → Everything up to A1 is selected
Select from the end.
Rectangle to A1
From row 500, Ctrl + Shift + Home → Rows 1 to 500 in the current column and everything left
A rectangle anchored at A1.
Frozen panes
With frozen panes, Ctrl + Shift + Home → Selects back to the first unfrozen cell
Same rule as Ctrl + Home.
Worth knowing
- Ctrl + Shift + End is the mirror image.
- Useful after Ctrl + End to select the whole used range from the bottom.
- In edit mode selects text to the start.
Where it goes wrong
- Frozen panes change the anchor.
- Rarely better than Ctrl + Home then Ctrl + Shift + End.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.