How to Insert Multiple Rows in Google Sheets

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.

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.

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.

1. 3. That’s it. I have my new row.

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.

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.

1. 3. As you can see, I have three new rows below the fifth row.

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.

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.

1. 3. That’s it. A new row has been 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.

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.

1. 3. That’s it. The new rows have been added above my selection.

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 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

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.