If you need several more rows in your spreadsheet, don’t waste time adding one row at a time. Google Sheets offers a few ways to add multiple rows, even between your existing rows, in your spreadsheets. We’ll show you how.

RELATED: How to insert multiple rows in Microsoft Excel

Use the Insert menu to add multiple rows

Using the Google Sheets “Insert” menu, you can add various elements to your sheet, including rows.

To use this method, first launch your spreadsheet in Google Sheets.

In your spreadsheet, select the row above or below which you want to add new rows. Click on the row number on the far left to select the row.

Select the row number on the far left.

Now select additional rows. For example, to add 3 new rows, select a total of 3 rows in your spreadsheet.

Select multiple rows.

On the Google Sheets menu bar, select Insert > Rows. Then, to add the new rows above the selected rows, choose “Insert X Rows Above”. To add the new rows below your selection, choose “Insert X rows below”.

Add new rows above or below the selection using

The new rows are now added to your spreadsheet.

New rows added to the sheet.

And that’s it.

Add multiple rows at once using context menu

Another way to insert multiple rows in Google Sheets is to use an option in the right-click or context menu.

To use this method, first open your spreadsheet in Google Sheets.

In your spreadsheet, click the row above or below which you want to insert new rows. Be sure to click on the row number on the far left to select your row.

Highlight a row.

Select additional rows in your spreadsheet. To add 2 new rows, select a total of 2 rows on your sheet. This includes the row you selected in the previous step.

Highlight multiple rows.

Right click on one of the selected rows. Then, to add rows above your selection, click “Insert X Rows Above” in the menu. To insert rows below your selection, choose “Insert X rows below”.

Google Sheets added the specified number of rows to your sheet.

New rows inserted in the sheet.

And everything is ready.

Add rows at the bottom of your sheet in Google Sheets

When you create a new sheet, Google Sheets gives you 1,000 rows to work with. If you need more, you can add additional rows using the menu at the bottom of your current sheet.

To do that, first launch your spreadsheet in Google Sheets.

Scroll to the bottom of your worksheet. To do this quickly, press Ctrl + Down Arrow (Windows) or Command + Down Arrow (Mac). Then press the down arrow key once.

At the bottom, you will see a text box. Here, enter the number of new rows you want to add to your current sheet. Then click the “Add” button.

Enter the row number and select

You now have the selected number of rows added to your current worksheet. Enjoy!


Want to add new columns to Google Sheets? If so, it’s equally easy to do that.

RELATED: How to add or remove rows and columns in Google spreadsheets