How to Insert Multiple Rows at Once in Excel

The fastest way to add multiple rows

To insert multiple rows at once in Excel, select the number of rows you want to add, then right-click and choose Insert. Excel will insert that many blank rows above your selection. For example, if you need 5 new rows, click on row 10, then hold Shift and click on row 14 to select 5 rows. Right-click the highlighted rows and select Insert Rows Above.

This method works in Excel for Windows, Mac, and the web version. The rows appear above wherever you started your selection, pushing your existing data down. All formulas and references in rows below the insertion point update automatically.

Key Takeaways

Select as many rows as you want to insert by clicking the first row number, then Shift-clicking the last row number in your range.
Right-click the selected rows and choose Insert to add blank rows above your selection.
You can also use the Home tab, click the dropdown arrow next to Insert, and select Insert Sheet Rows.
Excel automatically adjusts any formulas in rows below the new rows, so your calculations stay correct.
To insert rows at the end of your data, click a row below your last entry, select multiple rows, and insert — the new rows appear above your selection.

Selecting rows by clicking row numbers

The row numbers appear on the left edge of your spreadsheet. Click the number of the first row you want to insert rows above. The entire row highlights in blue.

Hold Shift and click the number of the last row in your range. If you want to insert 10 rows, click row 20, then Shift-click row 29. Excel selects all 10 rows at once. You can also click and drag from the first row number to the last, but Shift-clicking is faster and more precise.

Using the Insert menu instead of right-click

After selecting your rows, you can use the ribbon menu instead of right-clicking. Click the Home tab at the top of Excel. Look for the Insert button in the toolbar — it usually has a small dropdown arrow next to it.

Click the dropdown arrow and select Insert Sheet Rows. Excel inserts the same number of blank rows above your selection. This method works the same way as right-clicking, so use whichever feels faster to you.

What happens to your data and formulas

When you insert rows, everything below your selection moves down. If row 15 contained data, and you inserted 5 rows above it, that data is now in row 20. Excel shifts the row numbers automatically.

Any formula that refers to cells below the insertion point updates to point to the new row numbers. For example, if a formula in row 50 refers to cell B15, and you insert 5 rows above row 15, the formula now refers to B20. You do not need to fix formulas manually — Excel handles this for you.

Inserting rows in the middle of data

To add rows between existing data, click the row number where you want the new rows to appear. If your data goes from row 1 to row 100 and you want to insert 3 rows between row 50 and row 51, click row 51, then Shift-click row 53 to select 3 rows. Right-click and select Insert.

The new rows appear above row 51, pushing the old row 51 and everything below it down 3 rows. Your data splits at the insertion point, with the new blank rows in between. This is useful when you need to add information in a specific location without overwriting what is already there.

Inserting rows at the end of your spreadsheet

If you want to add rows after your last row of data, click a row number below your data. For example, if your data ends at row 100, click row 101. Hold Shift and click row 110 to select 10 rows. Right-click and select Insert.

The new rows appear above your selection, so they fill in rows 101 through 110. This is the same process as inserting in the middle — Excel always inserts above your selection, not below it. If you want rows to appear at the very end, make sure you select rows that are below your current data.

Frequently Asked Questions

Can I undo inserting rows if I make a mistake?

Yes. Press Ctrl+Z (Windows) or Command+Z (Mac) immediately after inserting. Excel removes the rows and restores your data to its previous state. You can undo multiple times if you need to go back several steps.

What is the maximum number of rows I can insert at once?

Excel allows you to insert as many rows as your spreadsheet can hold. The limit depends on your Excel version — most modern versions support over 1 million rows total. You can select and insert hundreds or thousands of rows at once without hitting a practical limit.

Do I have to insert rows above my selection, or can I insert below?

Excel always inserts rows above your selection. If you want rows to appear below a certain point, select the rows that are currently below where you want the new rows, then insert. The new rows appear above your selection, which places them where you intended.

Will inserting rows break my charts or pivot tables?

Charts and pivot tables that reference your data will update when you insert rows, similar to how formulas update. If a chart is based on rows 1 through 50 and you insert 5 rows in the middle, the chart automatically includes the new rows in its range. Check your charts after inserting to make sure they still look correct.

Can I insert rows in Excel on my phone or tablet?

Excel for mobile (iPhone, iPad, Android) supports inserting rows, but the process is slightly different. Open your spreadsheet, tap and hold a row number to select it, then tap the menu icon and choose Insert. The mobile version works the same way as the desktop version once you find the right menu.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.