Don’t forget to share this post

Do you need to insert multiple rows in your Google Sheet? If you're tired of adding them one by one, you’ll be happy to learn there’s another way to do it. In fact, there are a few ways to insert multiple rows in Google Sheets.

In this post, you will learn how to add new rows using the ‘Insert’ menu, the right-click menu, and the button on the bottom-left corner of your spreadsheet. Additionally, you will learn how to use shortcuts to add multiple rows even more quickly.

Layer Google Sheets Add On
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE

How to Insert Multiple Rows in Google Sheets?

As mentioned above, there are various methods you can use to insert multiple rows in Google Sheets. Below, you have step-by-step instructions on using each method: the ‘Insert’ menu, the right-click menu, the button on the bottom-left corner of the spreadsheet, and finally, the shortcuts, which will speed up the process even further.

Insert Multiple Rows in Google Sheets Using the Insert Menu

To insert new rows via the ‘Insert’ menu, follow these steps. First, you’ll learn how to insert a single row, then multiple rows.

Single Row

Follow these steps to add a single row.

  1. 1. Select the row above or below which you want to insert new rows.
How to Insert Multiple Rows in Google Sheets Select Row
How to Insert Multiple Rows in Google Sheets - Select Row
  1. 2. Go to Insert > Rows and choose whether to insert it above or below your selected row. For this example, I will add the new row below my selection.
How to Insert Multiple Rows in Google Sheets Insert Menu
How to Insert Multiple Rows in Google Sheets - Insert Menu
  1. 3. That’s it. I have my new row.
How to Insert Multiple Rows in Google Sheets Row Added
How to Insert Multiple Rows in Google Sheets - Row Added

Multiple Rows

Inserting multiple rows is just as easy as inserting a single one, but you need to select as many rows as you want to insert. For this example, I want to add three new rows below the fifth row, so I need to start by selecting three rows.

  1. 1. To select multiple rows, select the first one, then hold down ‘Shift’ and add the other rows to the selection.
How to Insert Multiple Rows in Google Sheets Select Rows
How to Insert Multiple Rows in Google Sheets - Select Rows
  1. 2. Once you have selected the appropriate number of rows, go to Insert > Rows. As you can see, the options at the top of the menu are now ‘Insert 3 rows above’ and ‘Insert 3 rows below’. For this example, I will choose the second option.
How to Insert Multiple Rows in Google Sheets Insert Menu 2
How to Insert Multiple Rows in Google Sheets - Insert Menu
  1. 3. As you can see, I have three new rows below the fifth row.
How to Insert Multiple Rows in Google Sheets Rows Added
How to Insert Multiple Rows in Google Sheets - Rows Added
How to Consolidate Rows in Excel Step by Step
How to Consolidate Rows in Excel (Step-by-Step)

When you have columns with multiple duplicate rows, you may want to combine the rows and sum the values. Here’s how to consolidate rows in Excel.

READ MORE

Multiple Rows in Google Sheets Using the Right-Click Menu

To insert multiple rows using the right-click menu, first select as many rows as you want to add to your spreadsheet. Once selected, right-click on your selection to get the menu. You can choose whether to add the rows above or below your current selection.

Below, you have step-by-step instructions on how to add a single row and multiple rows using the right-click menu.

Single Row

Adding a row using the right-click menu is even quicker than the previous method.

  1. 1. Select the row below or above which you want to add the new one.
How to Insert Multiple Rows in Google Sheets Select Row 2
How to Insert Multiple Rows in Google Sheets - Select Row
  1. 2. Right-click on the row number to see the right-click menu. You can choose whether to add it above or below your selection.
How to Insert Multiple Rows in Google Sheets Right Click Menu
How to Insert Multiple Rows in Google Sheets - Right-Click Menu
  1. 3. That’s it. A new row has been added.
How to Insert Multiple Rows in Google Sheets Row Added 2
How to Insert Multiple Rows in Google Sheets - Row Added

Multiple Rows

Now, let's see how to add multiple rows using the same method. For this example, I will be adding three new rows above the fourth row.

  1. 1. Select as many rows as you want to add. Below, I have selected the fourth, fifth, and sixth rows.
How to Insert Multiple Rows in Google Sheets Select Rows 2
How to Insert Multiple Rows in Google Sheets - Select Rows
  1. 2. Right-click on the row numbers of your selection to see the menu. In this case, I will add three rows above the fourth row.
How to Insert Multiple Rows in Google Sheets Right Click Menu 2
How to Insert Multiple Rows in Google Sheets - Right-Click Menu
  1. 3. That’s it. The new rows have been added above my selection.
How to Insert Multiple Rows in Google Sheets Rows Added 2
How to Insert Multiple Rows in Google Sheets - Rows Added
How to Remove Blank Rows in Excel
How to Remove Blank Rows in Excel? (Quick & Easy)

There are several quick and easy ways to remove empty cells in Excel spreadsheets. Here's how to delete blank rows in Excel.

READ MORE

Add Multiple Rows at the Bottom of the Google Sheet

If you want to add rows at the bottom, go to the bottom-left corner of your spreadsheet.

Type in the number of rows you want to add and click the ‘Add’ button.

How to Insert Multiple Rows in Google Sheets Add Rows Button
How to Insert Multiple Rows in Google Sheets - Add Rows Button

How to Add Rows in Google Sheets Using Shortcuts?

To insert multiple rows even more quickly, you can use shortcuts. Below, you have the shortcuts you can use in the Google Chrome browser on both Windows and Mac computers.

Windows Chrome Shortcuts

To insert rows above, use the following shortcut after selecting as many rows as you want to add.

Alt + i + r, then r

After selecting as many rows as you want to add, use the following shortcut to add the rows below your selection.

Alt + i + r, then b

Mac Chrome Shortcuts

Select as many rows as you want to add and use the following shortcut to insert them above your selection.

Ctrl + Option + i, then r

To insert rows below, select the number of rows you want to add and use this shortcut.

Ctrl + Option + i, then b

How to Automate Data Input on Top of Google Sheets?

Layer is an add-on that equips you with the tools to increase efficiency and data quality in your processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.

Using Layer, you can:

  • Share & Collaborate: Automate your data collection and validation through user controls.
  • Automate & Schedule: Schedule recurring data collection and distribution tasks.
  • Integrate & Sync: Connect to your tech stack and sync all your data in one place.
  • Visualize & Report: Generate and share reports with real-time data and actionable decisions.

Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your processes on top of Google Sheets!

Conclusion

You can use different methods to insert as many rows as you need in Google Sheets. You now know how to add rows using the ‘Insert’ menu, the right-click menu, and the button on the bottom-left corner of the spreadsheet. You also know how to use shortcuts to speed up the process when using the Google Chrome browser on both Windows and Mac computers.

Layer Google Sheets Add On
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE
Hady ElHady
Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

Originally published Dec 22 2022, Updated Dec 21 2022