ShortcutdrillExcel shortcuts / navigation / Jump to the last column of a row
Jump to the last column of a row in Excel: Ctrl+Right arrow (Mac: Cmd+Right arrow)
| Windows | Ctrl+Right arrow |
|---|---|
| Mac | Cmd+Right arrow |
| Group | navigation |
Drill: Jump to the last column. Free, no sign-up.
What it does and when to use it
Ctrl+Right moves to the last filled cell of the current row. Ctrl+Left brings you back to the first. It is the fastest way to check how wide a table is or to reach the last column of a schedule.
The common mistake
Using it in a row with an empty cell in the middle: it stops at the blank. Look at where it lands before you type.
Related shortcuts
- Jump back up to the header Ctrl+Up arrow
- Go to the start of the row Home
- Go to the last used cell Ctrl+End
- Find where a column stops Ctrl+Down arrow
- Cross a gap between two blocks Ctrl+Down arrow, twice
- The printable cheat sheet
Questions
How do I get to the last column with data?
From a cell inside the row, Ctrl+Right. From anywhere, Ctrl+End goes to the last used cell of the whole sheet.
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