In this article we will show you exactly how to insert multiple rows in Google Sheets. Just follow the simple steps below:
For the purposes of this demonstration a sample sheet was created. Click here to access the sample sheet and follow along at home.
Left click on a row number in your data set to highlight the entire row.
Hold shift on the keyboard for both Mac and PC and left click again to highlight additional rows.
The amount of new lines you will create will be the same as the amount of rows you select in total and these must be sequential.
For our example below, we have selected three.
In the file menu select Insert > Rows. You will be given the option to add X rows above or below your selection.
In our example we will insert 3 rows above.
In our example, 3 new rows will appear above the rows you selected.
As with steps one and two of the Menu Method, left click on a line number and hold down the Shift key on the keyboard for both Mac and PC and click to add additional sequential ones.
Right click anywhere on the highlighted lines for the menu to appear. Once again, you will generate the same amount of new lines as you have highlighted.
In the example below, we will select the option for 3 below.
The application is now complete with the new blank cells sitting between the lines of information already present.
In this article we demonstrated the application of how to add multiple new rows to Google Sheets via the Menu and Sidebar methods.
You might also like our articles on how to hide rows in Google Sheets and how to add a row in Google Sheets. Learn how to automatically send an email from Google Sheets with our easy-to-follow guide.
