In this article:

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

May 8, 2024

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
Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->