Select a row in Excel (Shift+Space)
Select the whole row of the active cell: press Shift+Space. Same on Mac and Windows.
| Action | Mac | Windows | |
|---|---|---|---|
| Select row | ⇧Space | Shift+Space | |
| Select column | ⌃Space | Ctrl+Space | |
| Insert row | ⌃⇧+ | Ctrl+Shift++ | |
| Delete row | ⌃- | Ctrl+- |
Select an entire row
Click any cell and press Shift+Space to select its whole row. Same keys on Mac and Windows. Add Shift+Arrow up or down to extend the selection.
Tip
With a row selected, Ctrl+Shift++ inserts a new row above and Ctrl+- deletes it.
More Excel row & cell moves
With cells selected you can fill right (Ctrl+R), open Format Cells (Ctrl+1), or jump anywhere with Go To (Ctrl+G).
FAQ
What is the select-row shortcut in Excel?
Press Shift+Space (same on Mac and Windows) to select the entire row of the active cell.
How do I select a whole column instead?
Press Ctrl+Space.
How do I delete the selected row?
With the row selected, press Ctrl+- (minus).