How To Add A Row In Google Sheets

In this tutorial, you will learn how to add a row in google sheets.

Often when working in Google Sheets you may find you need to insert data between pre-existing rows. While you could copy and paste all the data after the insertion point to make room for the new row of data, this would be time consuming and difficult. Fortunately, it’s possible to insert new rows anywhere in a Google Sheet. Here’s how:

Step 1

Locate the row you want to insert a row beside and right click on the row number at the left of the cells. In this example, we’ll add a row before row 2, so are right-clicking on the row 2 label

Step 2

Choose one of the Insert Row Above or Insert Row Below options depending on if you’d like to add the new row above or below the row you right clicked on

Step 3

A new blank row will be added in the specified location

Step 4

Note that you can also add multiple rows at a time by selecting multiple rows before right clicking on the row numbers and selecting a row insertion option


Quick Navigation

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add a row in google sheets. Want more? Check out all the Google Sheets Tutorials.