In this article:

How to Add a Row in Google Sheets (The Easy Way!)

Adding a row is a great way to insert data. In this article we will show you how to add a row in Google Sheets in just a few simple steps.

How to Add a Row in Google Sheets



We will now demonstrate the easiest method to insert a row in Google Sheets.

For this demonstration an example sheet was used. Click here to access the sample sheet and follow along at home.

Step 1: Select the Cell Below the New Row Destination

Click on any cell in the row below the destination for the new row.

In our example we will add a new row between rows 5 and 6. We can select any cell in row 6 as we are going to add the new row above.

How to insert row in Google Sheets: Select a cell

Step 2: Right Click and Select Insert 1 row above

With your cell selected right click, from the displayed menu select Insert 1 row above

How to insert row in Google Sheets: Right click menu

Alternatively from the top-toolbar select Insert followed by Rows. From the side menu you now have the option to Insert 1 row above. You can also use this menu to insert a row below. For this example we will choose to insert a row above our selection.

How to insert row in Google Sheets: Top-toolbar

 

Step 3: See the Results

A row is added to the data set above the initial cell selection.

How to insert row in Google Sheets: Results
Automate everything you track in spreadsheets with Lido
Learn more

Level up your Google Sheets skills with our free Google Sheets automation guide

Wasting too much time doing things manually in spreadsheets? Want to spend more time doing what you love? Our 100% free, 27-page Google Sheets automation guide is full of new tips and tricks that will save you time and money!