How to Insert Multiple Rows in Google Sheets [3 Easy Ways]

Watch Video – How to Insert Multiple Rows in Google Sheets

In case you prefer reading a tutorial over watching a video, below is a written tutorial for you.

When working with data in Google Sheets, you’ll often have a need to insert one of the multiple rows in between the existing rows (or at the top or bottom of the dataset).

Inserting rows in Google Sheets is pretty straightforward and only takes a couple of clicks.

But in case you want to insert rows multiple times in different places, even a few clicks can seem a lot. That where you can also used a cool shortcut.

Let’s dive in and see how to insert multiple rows in Google Sheets.

How to Insert a Single Row in Google Sheets (Above or Below)

If you only want to insert rows in Google Sheets one at time above or below a specific row, you can use the in-built feature made to do just this.

Using the Insert Tab

Suppose you have a dataset as shown below and you want to insert a row above row #4.

Insert Multiple rows in Google Sheets - Dataset

Below are the steps to insert a row above a specific row in Google Sheets:

  1. Select the row by clicking on the row header in the left (or any cell in the dataset)Click on row header to select the entire row
  2. Click the Insert tabClick on Insert tab
  3. Click on the ‘Row above’ optionClick on Row Above option

The above steps would insert one blank row above the fourth row as shown below.

A blank row is inserted

In case you want to insert a row below the selected row, choose the ‘Row below’ option in the ‘Insert’ menu drop-down.

Add Rows in Google Sheets Using the Right-Click Menu

You can also use the right-click method to quickly insert a single row or even multiple rows above or below the selected row.

Below are the steps to insert a row above the selected row using the right-click method:

  1. Select the row by clicking on the row header in the left (or any cell in the dataset)
  2. Right-click on the selection
  3. Click on the ‘Insert 1 above’ optionClick on Insert 1 above

The above steps would insert one row above the fourth row as shown below.

You can also use the same method to insert a row below the selected row. Just choose the ‘Row Below’ option in the third step.

Note: When you select the row header (the number at the extreme left of the row) and right-click, it shows you the option to insert a row above or below the selected row. But when you select a cell in the dataset and use right-click, it will only show you the option to insert the row above. This is one of the limitations in Google Sheets.

How to Insert Multiple Rows in Google Sheets (Above or Below)

Just like we have inserted a single row above and below the selected row, you can also insert multiple rows. The steps remain exactly the same with just one minor change. Follow these instructions for inserting multiple rows in Google Sheets with an appropriate row height.

 How to Insert More Than One Row in Google Sheets Using the Insert Tab

Suppose you have a dataset as shown below and you want to insert three rows above row #4.

Insert Multiple rows in Google Sheets - Dataset

Below are the steps of how to add multiple rows in  in Google Sheets:

  1. Select three rows starting from row #4 by selecting the row header in the left (or three cells in any row – starting from row #4)Select three rows above which you want to insert three blank rows
  2. Click the Insert tabClick on Insert tab
  3. Click on the ‘3 Rows above’ optionClick on Three Rows above option

The above steps would insert three blank rows above the selected rows (as shown below).

Three blank rows inserted above the three selected rows

Note: This would always insert as many rows as you as selected. If you select five rows, it will insert five blank rows above the selected rows.

You can also use the same method to insert multiple rows below the selected rows. Just choose the ‘3 Rows Below’ option in the third step.

Note: Unfortunately, at the time of writing this article, there is no way to selected non-contiguous rows and insert rows above each selected row. For example, if you select row # 5 and 8, and then try and insert one row above both these selected rows, you won’t be able to do this. If you click on the Insert option, in this case, you will see that it’s faded out and not available. However, this can be sped up by using a keyboard shortcut (covered later in this tutorial).

How to Insert Many Rows in Google Sheets Using the Right-Click Menu

Right-click menu is another way to insert multiple rows in Google Sheets. You can also group columns and rows through this menu.

Suppose you have a dataset as shown below and you want to insert three rows above row #4.

Below are the steps to insert multiple rows above the selected rows using the right-click method:

  1. Select three rows starting from row #4 by selecting the row header in the left (or three cells in any row – starting from row #4) You could also hold Shift and press each row individually
  2. Right-click on the selected row headers (or cells, in case you have selected cells)
  3. Click on the ‘Insert 3 above’ optionRight click and then click on Insert three above

You can also use the same method to use Google Sheets to insert multiple rows below the selected rows. Just choose the ‘3 Rows Below’ option in the third step. This works similarly to adding multiple columns.

How to Add More Rows in Google Sheets Using the Keyboard Shortcut (F4)

In case you want to insert multiple rows which are not contiguous. For example, you want to insert rows above row #3, 5 and 8. Since these rows are not one after the other, you can do this at one go.

One of your options is to insert each row one-by-one by following one of the methods covered earlier.

And then there is another way to use a keyboard shortcut F4. While this shortcut will not do this all at once, it does speed up the process.

Below are the steps to insert multiple rows in Google Sheets (above row # 3, 5, and 8) which are not contiguous:

  1. Select the row by clicking on the row header of row #3 (or any cell in the dataset)
  2. Click the Insert tab
  3. Click on the ‘Row above’ option. This will insert one row above row #3
  4. Select any cell in row #5
  5. Hit the F4 key
  6. Select any cell in row #8
  7. Hit the F4 key

Insert Multiple Rows using F4 keyboard shortcut

The F4 key simply repeats your last action, and in this case, since the last action was to insert a row above the selected row, it simply repeats that to make a Google Sheets add row shortcut.

While it may seem like too many steps, when you actually do this in Google Sheets, this process is pretty fast.

Note: Remember that F4 simply repeats the last action you did in Google Sheets. So if you do something while in the process of inserting rows (such as copy-paste or anything else), using F4 after that will repeat that action and not insert the row. You will now have to insert a row using tab or right-click method and then you can start using F4 again.

How to Insert Multiple Rows on Mac + Keyboard Shortcut

The keyboard shortcut of F4 remains the same on a Mac. But, Macs don’t right-click. Instead of opening the menu with a right-click, you must hold control and click instead.

Add Multiple Rows in Google Sheets FAQ

Can I Insert More Than 1 Row at a Time in Google Sheets? / Can Google Sheets Insert Multiple Rows?

Yes, you can add more than 1 row into Google Sheets at a time. You just have to:

  1. Hold Ctrl and left-click over the number of rows you want to add in the row header
  2. Right-click in the selected row headers
  3. Click Add x rows above or below

How Do I Automatically Add Rows in Google Sheets?

If adding rows was the last action you completed you can automatically add the same amount again by using the F4 keyboard shortcut.

How Do You Insert Multiple Rows in Google Sheets on a Mac?

Press Control and click on the selected row headers to open the menu that has the Add X rows option on a Mac.

How Do I Copy and Paste Multiple Rows in Google Sheets?

You can use the Ctrl+C and Ctrl+V shortcuts on selected rows to copy and paste them.

What to Learn Next

Now that you know how to insert multiple rows in Google Sheets, you may need to learn some more complex tasks. Check out some of our tips to help you master this complex program.

 

Most Popular Posts

Sumit

Sumit

Google Sheets and Microsoft Excel Expert.