ShortcutdrillExcel shortcuts / editing / Insert a row
Insert a row in Excel: Shift+Space, Ctrl+Shift+= (Mac: Shift+Space, Control+Shift+=)
| Windows | Shift+Space, Ctrl+Shift+= |
|---|---|
| Mac | Shift+Space, Control+Shift+= |
| Group | editing |
Drill: Insert a row. Pro drill. Twenty-five drills are free.
What it does and when to use it
Shift+Space selects the row, Ctrl+Shift+= (Ctrl+Plus) inserts a blank row above it. The same pair with Ctrl+Space inserts a column.
The common mistake
Inserting inside a range a SUM covers and expecting the total to include the new row. It does if the row is inside the range, not if it is at the edge.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
How do I insert several rows at once?
Select as many rows as you want to insert, then Ctrl+Shift+=.
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