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:
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
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
A new blank row will be added in the specified location
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
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.