How To Add Multiple Rows in Excel
With each of the methods below, you’ll start by selecting a range of rows corresponding to the number of rows you want to insert. You can do this using one of these methods:
Drag through the range of rows.Select the first row, hold your Control key (Command on Mac), and select each subsequent row.Select the first row, hold your Shift key, and select the last row in the range.
When you use the Insert action described below, the rows will be added above the first row you select.
Insert Multiple Rows in Excel with a Right-Click
If you’re an Excel user who likes to use as few moves as possible to accomplish tasks, then this method for inserting multiple rows is for you.
Insert Multiple Rows in Excel with the Ribbon
Maybe you’re not comfortable with right-clicking or are using a trackpad or touchpad where it’s not as easy. This method lets you hit a button to insert your rows, and you can choose to use current rows or cells to insert rows.
Use Rows to Insert Rows
This method is similar to the one above where you’ll select a range of rows.
Use Cells to Insert Rows
Many times, it’s simpler to select a range of cells rather than rows. You can use this method to insert rows by selecting cells.
Insert Multiple Rows in Excel with the Menu Bar (Mac Only)
While all of the above methods work perfectly fine in Excel on macOS, if you’re a Mac user, you have one extra option to insert multiple rows.
