Insert row in Excel shortcut

Windows

Mac

Press Shift+Space to select the row, then Ctrl+Shift+= (Ctrl and plus) on Windows or Cmd+Shift+= on a Mac. The new row appears above.

Variants and related combos

Where / whatWindowsMac
Select the row first
Delete the selected row

Source: Microsoft Support: Keyboard shortcuts in Excel.

Try it now

Click the pad below, then press the shortcut. Nothing happens to this page; we just listen.

Waiting for your keys…

Practise it with the rest of the set

One shortcut sticks better alongside its neighbours. These trainers include it:

Questions

What is the insert row in excel shortcut?

Press Shift+Space to select the row, then Ctrl+Shift+= (Ctrl and plus) on Windows or Cmd+Shift+= on a Mac. The new row appears above.

More quick answers