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.
You can use a very similar method to insert a column in Google Sheets as well.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.