ShortcutdrillExcel shortcuts / navigation / Go to the last used cell
Go to the last used cell in Excel: Ctrl+End (Mac: Fn+Cmd+Right arrow)
| Windows | Ctrl+End |
|---|---|
| Mac | Fn+Cmd+Right arrow |
| Group | navigation |
Drill: Find the end of the data. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+End moves to the bottom-right corner of everything the sheet has ever used. If it lands far below your data, the sheet carries formatting or leftovers that bloat the file.
The common mistake
Reading the landing cell as the end of the data: it is the end of the used range, which includes formatted empty cells. Delete those rows and save to reset it.
Related shortcuts
- Jump to the last column of a row Ctrl+Right arrow
- Return to cell A1 Ctrl+Home
- Jump back up to the header Ctrl+Up arrow
- Go to the start of the row Home
- Find where a column stops Ctrl+Down arrow
- The printable cheat sheet
Questions
Why does Ctrl+End go to an empty cell?
Something was once entered or formatted there. Delete the rows and columns beyond your data, save the file, and Ctrl+End will land on the real last cell.
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