How to Insert a Row in Google Sheets

Very rarely will you create a spreadsheet that doesn’t require some editing. If you need to add extra information to a spreadsheet, then often it will be possible to do so by simply adding it to the next empty row in the sheet.

But occasionally the order of your data might matter, and you need to add a row of information amidst rows that already contain data of their own. Fortunately Google Sheets gives you the option to insert rows above or below existing rows, which allows you to add data rows at any point within your existing spreadsheet. Our guide below will show you a couple of different ways that you can do this.

If you also use tables in your documents, then our how to add another row to a table in Google Docs guide can show you several ways to modify those tables.

How to Add a Row in Google Sheets

The steps in this article were performed in Google Chrome, but will work in other desktop Web browsers as well. Steps may vary on mobile devices, or in apps.

Step 1: Go to your Google Drive at and open the spreadsheet to which you want to add a row.

Step 2: Select the gray row number at the left side of the spreadsheet to which you would like to insert a row above or below.

select row number in google sheets

Step 3: Click the Insert tab at the top of the window.

insert google sheets

Step 4: Select the Row above or the Row below option.

how to add row in google sheets

Note that you can also insert a row in Google Sheets by right-clicking the row number, then selecting the Insert 1 above or Insert 1 below option.

how to insert row google sheets

You can use a very similar method to insert a column in Google Sheets as well.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy