Select to the start of the row in Excel

Select to the start of the row in Excel: Shift+Home (Mac: Fn+Shift+Left arrow)

Windows	`Shift+Home`
Mac	`Fn+Shift+Left arrow`
Group	selection

Practice this shortcut

Drill: Select to the start of the row. Pro drill. Twenty-five drills are free.

What it does and when to use it

Shift+Home selects from the active cell to column A of the same row. Combined with Shift+Down it builds a block that starts at the left edge.

The common mistake

Forgetting it exists and pressing Shift+Left many times.

Related shortcuts

Select to the last used cell Ctrl+Shift+End
Select back to A1 Ctrl+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 the current cell to the left edge?

Shift+Home. Ctrl+Shift+Left stops at the first filled cell instead, which may be short of column A.

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