In this article:

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

January 13, 2025

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

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages