How To Insert Multiple Rows In Google Sheets? Complete Guide

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

How To Insert Multiple Rows In Google Sheets

Now follow the given steps to insert a row above.

  1. First, select a row by clicking the row header on left.

How To Insert Multiple Rows In Google Sheets

  1. Click Insert tab

How To Insert Multiple Rows In Google Sheets

  1. Now click on the row above option and your job is done.

How To Insert Multiple Rows In Google Sheets

By following the above steps, one blank row above the 6th row will be inserted.

Insert Multiple Rows In Google Sheets

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.

  1. Again, you need to select the row by clicking on the row header.

How To Insert Multiple Rows In Google Sheets

  1. Now right-click in the selected cell.
  2. And now click on insert 1 above.

Insert Multiple Rows In Google Sheets

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.

How To Insert Multiple Rows In Google Sheets

Now, if you want to add four rows above the #6 row then follow the below steps.

  1. Select 4 rows starting from #6.

Add Multiple Rows In Google Sheets

  1. Click on the Insert tab.

Add Multiple Rows In Google Sheets

  1. And now click on ‘insert 4 rows above’.

Add Multiple Rows In Google Sheets

  1. This will add 4 rows above as below.

Add Multiple Rows In GSheets

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.

  1. First, you need to select three rows starting from row #5.

How to Add Multiple Rows In Google Sheets

  1. Now, right-click and select the insert above option to add three rows above.

How to Add Multiple Rows In Google Sheets

This will insert 3 rows above the selected row.

How to Add Multiple Rows In Google Sheets

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.

  1. First, you need to insert a single row with the help of either the insert tab or right-click menu.
  2. 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.

Leave a Reply