Excel like a finance pro.
← The libraryPractice · 2 questions →
Selection shortcut
Select the entire row
Shift + Space on Windows, Shift + Space on Mac.
Very commonDifficulty 950 · Capable
When to use it
Selects the entire row of the active cell.
The shape of it
- Windows
Shift + Space
- Mac
Shift + Space
Worked examples
Select a row
Click a cell in row 7, press Shift + Space → Row 7 is selected
Then delete, hide, or format it.
Delete a row
Shift + Space, then Ctrl + - → The row is deleted
Delete without the mouse.
Hide rows
Shift + Space, Shift + ↓ three times, Ctrl + 9 → Four rows hidden
Hide a block of rows.
Worth knowing
- Ctrl + Space selects the column.
- In a Table, the first press selects the Table row only.
- Shift + Space then Ctrl + Shift + + inserts a row.
Where it goes wrong
- In edit mode it types a space.
- Selecting whole rows and then pasting can overwrite far more than intended.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.