Select across a row in Excel

Select across a row in Excel: Ctrl+Shift+Right arrow (Mac: Cmd+Shift+Right arrow)

Windows	`Ctrl+Shift+Right arrow`
Mac	`Cmd+Shift+Right arrow`
Group	selection

Practice this shortcut

Drill: Select across a row. Pro drill. Twenty-five drills are free.

What it does and when to use it

Ctrl+Shift+Right selects from the active cell to the last filled cell on the right. It selects the header row of a table in one press, ready for bold or a border.

The common mistake

Pressing it in a row with a blank cell: the selection stops there. Press again to extend across the gap.

Related shortcuts

Select to the last used cell Ctrl+Shift+End
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
The printable cheat sheet

Questions

How do I select the whole header row of a table?

From the first header cell, Ctrl+Shift+Right. For the entire sheet row including empty cells, Shift+Space.

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