ShortcutdrillExcel shortcuts / selection / Select to the last used cell
Select to the last used cell in Excel: Ctrl+Shift+End (Mac: Fn+Cmd+Shift+Right arrow)
| Windows | Ctrl+Shift+End |
|---|---|
| Mac | Fn+Cmd+Shift+Right arrow |
| Group | selection |
Drill: Select to the last cell. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+End selects from the active cell to the last used cell of the sheet. From the first data cell it selects the whole table, even with gaps inside it.
The common mistake
Using it on a sheet with stray formatting below the data: the selection runs to the formatted cells. Clean those rows first.
Related shortcuts
- Select back to A1 Ctrl+Shift+Home
- Select to the start of the row Shift+Home
- Select the region without the mouse Ctrl+A or Ctrl+Shift+8
- Select to the end of the column Ctrl+Shift+Down arrow
- Select a block from its top-left cell Ctrl+Shift+Right arrow, Ctrl+Shift+Down arrow
- The printable cheat sheet
Questions
How do I select from a cell to the end of the data?
Ctrl+Shift+End. If the sheet has leftovers below, Ctrl+Shift+Down then Ctrl+Shift+Right is safer.
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