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.


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.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.