Keyboard shortcut to insert a row in Excel

Question

Inserting rows with right click is slowing me down. Is there a shortcut that adds a row above the one I'm on? Using Excel on Windows.

ankita.ahuja · Answer

Shift+Space to select the row, then Ctrl and the plus key. New row goes above. Select several rows first and it inserts that many.

jay_tech · Answer

on a laptop without a number pad the plus is Ctrl+Shift+= , same thing.

Leave A Reply