ShortcutdrillExcel shortcuts / grouping and structure / Delete a blank row
Delete a blank row in Excel: Shift+Space, Ctrl+- (Mac: Shift+Space, Cmd+-)
| Windows | Shift+Space, Ctrl+- |
|---|---|
| Mac | Shift+Space, Cmd+- |
| Group | grouping and structure |
Drill: Delete the blank row. Free, no sign-up.
What it does and when to use it
The blank row left by an export or a moved block: Shift+Space selects it, Ctrl+Minus removes it, the rows below move up. Two presses instead of a right-click.
The common mistake
Deleting a row that only looks blank but holds a space or formatting that a total depends on. Check with Ctrl+Down whether the data really stops there.
Related shortcuts
- Insert a column Ctrl+Space, Ctrl+Shift+=
- Group rows Alt+Shift+Right arrow
- Ungroup rows Alt+Shift+Left arrow
- Collapse the groups Alt, A, H
- Insert a sheet Shift+F11
- The printable cheat sheet
Questions
How do I delete every blank row at once?
Select the column, Ctrl+G, Alt+S, K for blanks, Enter, then Ctrl+Minus with Entire row.
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