There are several methods one can use to insert multiple rows in Excel.

But first, you need to know how to insert a single row in Excel.

Option 1:

To insert a new row in Excel:

  • First, find the row where you want to insert the new row.  For example, if you want to insert the new row in row 2, that’s the row you should target. In other words, if you want to insert the new row between row 2 and row 3, then row 3 is where you should target.
  • Right-click the row header at the left of the sheet. A shortcut menu appears.
  • Choose Insert from the shortcut menu.

See screenshot:

Insert new rows in Excel

How to insert multiple rows in Excel

  • Highlight as many rows you wish to insert.
  • Then right-click and select Insert from the shortcut menu.

Excel will insert the new rows based on the number of rows you select. However, all the selected rows will be pushed down when those new rows are inserted.

See screenshot:

how to insert multiple rows in excel

See Also:

Option 2:

  • Click any cell in the row you wish to insert.
  • Then go to Home → Cells → Insert → Insert Sheet rows
Insert new rows in Excel

In either option, Excel inserts a new row and automatically push all the other rows down. Thus, if you add a row after row 2, the old row 3 becomes row 4, the old row 4 becomes row 5, and so on.

Even though the number of rows in Excel is fixed, you can still insert new rows to make room for additional information. However, this operation doesn’t change the number of rows Excel has. Rather, inserting new rows shift down the other rows.

NOTE: You can only insert new rows on condition that the last row doesn’t contain any data. In such a situation, attempting to add a row will fail with the following dialog box:

Insert new rows in Excel Error