Friends, when you work with Google sheets you often feel the need to insert multiple rows in between existing rows.
It is pretty straightforward and can be done with a few clicks only, however, I have seen beginners struggling and they often wonder how to insert multiple rows in Google Sheets.
Here is a video tutorial for you. You can follow the same steps or you can refer to our step-by-step guide on how to add multiple rows in one cell in google sheets.
Video source – Youtube
There are various scenarios where you need to insert multiple rows at different places, and there few clicks seem like a burden. But don’t worry, as we are here to give you some cool shortcuts.
How To Add Rows ‘One At A Time’ In Google Sheets?
If you want to add one row at a time below or above a specific row then you can simply use an in-built feature that is made to do only this.
Use Insert Tab
Let’s say you have a data-set as below and you want to insert a row above #6
Now follow the given steps to insert a row above.
- First, select a row by clicking the row header on left.
- Click Insert tab
- Now click on the row above option and your job is done.
By following the above steps, one blank row above the 6th row will be inserted.
Now, if you want to insert a row below the selected row then simply choose the option of “Row below” and you will see a blank row below the selected row.
Insert Rows Above And Below In Google Sheets With Right-Click Menu
To make the process quick you can use the right-click method to quickly insert single/multiple rows.
Follow the below steps for the same.
- Again, you need to select the row by clicking on the row header.
- Now right-click in the selected cell.
- And now click on insert 1 above.
With the help of these steps, you can easily insert rows above the 6th row.
Note – The same method can be used to insert a row below the selected row. You just need to select the row below option.
How To Insert Multiple Rows In Google Sheets(Above & Below)?
If you want to add multiple rows above or below a row you need to follow the same steps with a slight change.
With Insert Tab
Let’s use the same data set again.
Now, if you want to add four rows above the #6 row then follow the below steps.
- Select 4 rows starting from #6.
- Click on the Insert tab.
- And now click on ‘insert 4 rows above’.
- This will add 4 rows above as below.
Note- With the help of this method you will add as many rows as you want. So, if you select 6 or more rows then it will insert rows accordingly.
The same method is used to add multiple rows at the bottom. Here you just need to click on ‘insert rows below.
Insert Multiple Rows With Right-Click Menu
You can insert multiple rows in google sheets quickly with the help of right-click menu.
Let’s say, you have the same data set and you want to insert 3 rows above row 5. Follow the below steps to do the same.
- First, you need to select three rows starting from row #5.
- Now, right-click and select the insert above option to add three rows above.
This will insert 3 rows above the selected row.
How To Add Multiple Lines In Google Sheets Using Keyboard Shortcut?
If you want to add multiple rows (not above/below the same row) then you can simply use a keyboard shortcut and your job is done.
To do the same you need to follow the below steps.
- First, you need to insert a single row with the help of either the insert tab or right-click menu.
- When you have added a single row, then you need to select another row where you wish to add a new row and then press F4.
Similarly, you can add as many rows as you want. Just select the row and click on the F4 button.
If you wish to add multiple rows above a single selected row, then press F4 multiple times and your new rows will be created.
I hope, now you are clear with how to insert multiple rows in Google Sheets. If you have any doubt then do let us know in the comment section or you can contact us. We will be happy to resolve your problem on priority.