Insert Row Shortcut in Excel

There are different ways to use the Insert Row Shortcut in Excel to add a blank row above the selected row and speed up your work.


Ctrl Shift +


Shift +

Steps to insert a new row using the keyboard shortcut:

  1. Click the row number to select a row
  2. Hold down the Control and Shift key and press the plus (+) sign

Learn more about Excel Shortcuts!

Insert a new row without a shortcut

Step 1. Select the row number

select the row number

Step 2. Right-click on the row to open the context menu

click insert

Step 3. Click the ‘Insert’ command. Excel will add a new row above the selected row.

Tip: If you want to add multiple rows simultaneously, select multiple rows and repeat the steps above.

Recommended articles:

Istvan Vozar

Istvan is the co-founder of Visual Analytics. He helps people reach the top in Excel.