How to Insert Multiple Rows In Google Sheets Using Insert Tab

How to Add a Row Using Insert Row Icon in Google Sheet

How to Insert Rows in Google Sheets Shortcut

To insert multiple rows in Google Sheets, the above steps are followed the only difference is that instead of selecting a single row above or below which you want to add a new row, you need to select a number of rows you want to add. For Example, if you want to add four rows below a row say row number 5, then you need to select four rows and continue following the above steps.

Step 1: Select the Rows and Click on Insert

First, select the multiple rows in between or anywhere you want to add the rows.

Figure 1: Select Multiple rows

Step 2: Multiple rows are inserted

The number of rows you will select the more rows will be inserted in the google sheets.

Multiple Rows Inserted

Note: -The more rows you will select the more rows will be added to the sheets.