This article shows you how to insert multiple rows in Microsoft Excel. The instructions apply to Excel on both Windows and macOS.

What To Know

  • Select the same number of rows that you want to insert, right-click, and pick Insert.Select the same number of rows that you want to insert and click Insert on the Home tab.Select the number of cells corresponding to the number of rows you want to insert and click Insert > Insert Sheet Rows on the Home tab.

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.

  • Select the same number of rows that you want to insert.
  • Right-click within of the range of selected rows.
  • Pick Insert.

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.

Select the same number of rows that you want to insert. 

Right-click within of the range of selected rows.

Pick Insert.

Use Rows to Insert Rows

This method is similar to the one above where you’ll select a range of rows.

  • Select the same number of rows that you want to insert.
  • Go to the Home tab.
  • Click Insert which displays in the Cells section.

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.

Select the same number of rows that you want to insert.

Go to the Home tab.

Click Insert which displays in the Cells section.

  • Select the same number of cells as the number of rows you want to insert.
  • Go to the Home tab.
  • Click the arrow next to Insert and choose Insert Sheet Rows.

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.

Select the same number of cells as the number of rows you want to insert.

Click the arrow next to Insert and choose Insert Sheet Rows.

  • Select either the same number of rows or cells as the number you want to insert.
  • Click Insert in the menu bar.
  • Choose Rows from the menu.

Select either the same number of rows or cells as the number you want to insert.

Click Insert in the menu bar.

Choose Rows from the menu.

Get the Latest Tech News Delivered Every Day