Select the row header of where you want to add the row.You can just right-click instead of navigating to the Insert menu too. In this example, we want a row below.Īdd a Single Row to Google Sheets With a Right Click Click the Insert tab at the top of the page.Click the row header on the left-hand side to select the entire row.Using the Insert Tab to Add a Rowįrom here, we want to add a row between rows 3 and 4. There are two easy-to-follow methods to do this. It’s much easier to do this than to use the above steps for inserting multiple rows in Google Sheets. When adding rows in Google Sheets, you sometimes only need one extra row. How to Add Rows in a Google Spreadsheet One at a Time However, in Google Sheets, you will have to do this one by one. For example, in Excel, you can insert five rows between row #5 and #6, rows #7 and #8, row #10 and #11 at one go. However, if you need to get this done for many rows, for example, insert 5 rows between all the rows, you will still need to do this one set at a time.Īgain, this is one area where Excel has the upper edge as you can insert multiple rows in Excel for many numbers of rows at one go. This technique works well when you have to insert multiple rows in Google Sheets between two rows. Note that you can also select rows 1-5 and then right click and select the option ‘Insert 5 below’. This would instantly insert 5 blank rows between rows #5 and row #6. Right-click on any of the selected row number.Select 5 rows starting from row number 6.You can use the following method to add multiple rows in Google Sheets. Suppose you have a dataset as shown below and you want to insert 5 rows between row number 5 and 6. Steps to Insert Multiple Rows in Google Sheets

There are a few easy-to-follow steps to make Google Sheets insert multiple rows. While this can be a valid method to do this, it is time-consuming and inefficient. What do you do when you want to insert multiple rows in Google Sheets?

How to add multiple rows in excel