See all How-To Articles

How to Insert Blank Row in Excel & Google Sheets

This tutorial demonstrates how to insert a blank row in Excel and Google Sheets.

 

InsertRow Intro

 

Insert Rows

There are numerous quick ways to insert a blank row into your Excel worksheet.

Excel Ribbon

Select the row where you wish the new row to go, then in the Ribbon, select Home > Insert > Insert Sheet Rows.

 

InsertRow Ribbon

 

A new row is inserted above the selected row.

To insert more than one row, select the required number of rows in the worksheet, then select Insert Sheet Rows on the Ribbon.

 

InsertRow SelectMultiple

 

Quick Menu

Right-click on the row header where you wish to insert a new row, and select Insert.

 

InsertRow RightClick

 

You can also select multiple rows, then right-click and select Insert to insert multiple rows into the worksheet.

 

InsertRow InsertMultiple

 

Use the Keyboard

To select a single row with the keyboard, hold down the SHIFT key and press the Spacebar.

To select multiple rows, hold down the SHIFT key and press SPACE, then the Down Arrow.

To insert a new row or rows, press and hold CTRL, then press the Plus sign.
OR
Hold down the ALT key and press I, then R.

NOTE: Keyboard shortcuts insert as many rows as are selected.

Insert Blank Row in Google Sheets

Google Sheets has a menu option and a Quick Menu option to insert rows.

Menu

To insert a single row using the menu, select the row where you want the new row inserted, then in the Menu, select Insert > Rows > Insert 1 row (above or below).

 

InsertRow GS Menu Insert

 

To insert multiple rows using the menu, select the number of rows you want inserted, then in the Menu, select Insert > Rows > Insert n rows (above or below) where n is the number of rows selected.

 

InsertRow GS Menu Insert Multiple

 

Right-Click

To insert a single row using the Quick Menu, select the row where you want the new row inserted, then right click to obtain the Quick Menu. Click Insert 1 row (above or below).

 

InsertRow GS QuickMenu Insert

 

To insert multiple rows using the Quick Menu, select the rows where you want the new rows inserted, then right click to obtain the Quick Menu. Click Insert n rows (above or below) where n is the number of rows selected.

 

InsertRow-GS-QuickMenu Insert Multiple