Excel insert row shortcut: Ctrl + Shift + +
Add a blank row above the selected row, without the mouse.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
* Based on the keyboard layout, not tested on a real keyboard (only the Croatian one was tested). If the shortcut does not work, use the matching button on the ribbon.
What it does
Ctrl + Shift + + (Ctrl, Shift and the plus key) inserts a blank row above the row you selected. With only one cell selected, Excel asks whether to shift cells down or insert a whole row.
When to use it
Use it when you forgot an item in a list and need a gap in the middle. Select the row first with Shift + Space, so the new row is inserted at once and the data below moves down.
How to do it
- Click a cell in the row below where you want the new row.
- Press Shift + Space to select the whole row.
- Press Ctrl + Shift + + (on a Mac: Control + I). A blank row appears above.
A quick example
Your team list has Sam in row 4, and you need to add Pia before Sam. Click a cell in row 4, press Shift + Space, then Ctrl + Shift + +. A blank row 4 appears, and Sam moves to row 5.
Insert row, Insert cells and Ctrl + minus
With a whole row selected, Ctrl + Shift + + inserts a row. With cells selected it opens the Insert window. The opposite shortcut, Ctrl + minus, deletes the selected row, but it does not work in Excel for the web, so there you right-click the row number and choose Delete.
Shortcuts mentioned on this page, with video:
Not working? Check this
- A small window opens: you had cells selected, not a whole row. Choose Entire row, or press Shift + Space first.
- Nothing happens: click into the sheet, not into the formula bar, and use the plus key with Shift on the row above the letters.
- On a Mac the shortcut is Control + I.
- Nothing happens at all: on Windows, Ctrl + Shift can switch the keyboard language, so Excel never gets the keys. If the language indicator in the taskbar changes when you press them, turn that shortcut off under Settings, Time & language, Typing, Advanced keyboard settings, Input language hot keys (the names can differ a little by Windows version).
Quick answers
What is the shortcut to insert a row in Excel?
Select the row with Shift + Space, then press Ctrl + Shift + +. On a Mac use Control + I.
How do I insert several rows at once?
Select as many rows as you want to add, for example three, then press Ctrl + Shift + +. Three blank rows appear above.
How do I delete a row with a shortcut?
Select the row and press Ctrl + minus. In Excel for the web this shortcut does not work, so right-click the row number and choose Delete.

