Back to the top left from anywhere in Excel

Back to the top left from anywhere in Excel: Ctrl+Home (Mac: Fn+Ctrl+Left arrow)

Windows	`Ctrl+Home`
Mac	`Fn+Ctrl+Left arrow`
Group	navigation

Practice this shortcut

Drill: Back to the top left. Free, no sign-up.

What it does and when to use it

Wherever you are, Ctrl+Home puts the active cell at A1 (or the first unfrozen cell). Press it before you hand a file over, so it opens at the top.

The common mistake

Saving a workbook with the active cell deep in the sheet. The next person opens it there.

Related shortcuts

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
Jump back up to the header Ctrl+Up arrow
The printable cheat sheet

Questions

Is there a shortcut to go to the top of the current column?

Ctrl+Up goes to the first filled cell above. Ctrl+Home goes to A1 regardless of column.

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