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 https://drive.google.com/drive/my-drive 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.

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

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

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.