ShortcutdrillExcel shortcuts / navigation / Find the last cell on a wide sheet
Find the last cell on a wide sheet in Excel: Ctrl+End (Mac: Fn+Ctrl+Right arrow)
| Windows | Ctrl+End |
|---|---|
| Mac | Fn+Ctrl+Right arrow |
| Group | navigation |
Drill: Last cell on the sheet. Pro drill. Twenty-five drills are free.
What it does and when to use it
On a sheet that extends to the right as well as down, Ctrl+End goes to the corner where both end. Follow it with Ctrl+Home to size the sheet in two presses.
The common mistake
Forgetting hidden columns: Ctrl+End counts them, so the landing cell can be out of sight.
Related shortcuts
- Back to the top left from anywhere Ctrl+Home
- Select every error cell Ctrl+G, Alt+S, K, Enter
- Jump to the edge of the data Ctrl+Arrow
- Jump to the last column of a row Ctrl+Right arrow
- Return to cell A1 Ctrl+Home
- The printable cheat sheet
Questions
Why does Ctrl+End select a cell I cannot see?
The column or row is hidden. Unhide with Ctrl+Shift+0 or Ctrl+Shift+9 after selecting across it.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill