ShortcutdrillExcel shortcuts / selection / Select the whole row
Select the whole row in Excel: Shift+Space (Mac: Shift+Space)
| Windows | Shift+Space |
|---|---|
| Mac | Shift+Space |
| Group | selection |
Drill: Select a whole row. Free, no sign-up.
What it does and when to use it
Shift+Space selects the entire row of the active cell, across every column. It is the first step before inserting, deleting, hiding or grouping rows from the keyboard.
The common mistake
Pressing it with several cells selected across rows: it selects all those rows, which is usually what you want but can surprise.
Related shortcuts
- Select a column of data Ctrl+Shift+Down arrow
- Select across a row Ctrl+Shift+Right arrow
- Select the whole column Ctrl+Space
- Select the current table Ctrl+A
- Select to the last used cell Ctrl+Shift+End
- The printable cheat sheet
Questions
How do I select several rows at once?
Select cells spanning the rows with Shift+Down, then Shift+Space. Or Shift+Space first, then Shift+Down to extend.
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