The fastest way to insert multiple rows at once

To add multiple rows in Excel, select the number of rows you want to insert, right-click, and choose Insert. Excel will insert that many blank rows above your selection. If you need 10 new rows, select 10 existing rows first — the selection size tells Excel how many to add.

This is faster than inserting one row at a time, especially when you need to add dozens of rows to a large spreadsheet. The rows appear above whatever you selected, so plan your selection accordingly.

Key Takeaways

  • Select as many rows as you want to insert, then right-click and choose Insert to add them all at once above your selection.
  • Click the row number on the left side of the spreadsheet to select an entire row, then hold Shift and click another row number to select multiple rows in a block.
  • New rows inherit the formatting (colors, fonts, borders) from the rows directly above them, which can save time if you want matching appearance.
  • You can undo an insertion when ready by pressing Ctrl+Z (Windows) or Command+Z (Mac) if you inserted rows in the wrong location.

Selecting multiple rows by clicking row numbers

The row numbers appear along the left edge of your spreadsheet — 1, 2, 3, and so on. Click any row number to select that entire row. The row highlights in blue, showing it is selected.

To select multiple rows in a row, click the first row number you want, then hold Shift and click the last row number. Excel selects everything between them. If you want rows 5 through 14, click the 5, hold Shift, and click the 14. All 10 rows highlight at once.

To select rows that are not next to each other — say row 3 and row 7 — click row 3, then hold Ctrl (Windows) or Command (Mac) and click row 7. Both rows highlight. You can add more non-consecutive rows the same way, holding Ctrl or Command each time.

Right-clicking and choosing Insert

Once your rows are selected, right-click anywhere on the highlighted rows. A menu appears with several options. Look for Insert and click it. Excel inserts new blank rows above your selection — the number of new rows matches the number you selected.

If you selected 5 rows, you get 5 new blank rows. If you selected 20 rows, you get 20 new blank rows. The original rows you selected move down to make room.

On some versions of Excel, the menu may say Insert Rows Above instead of just Insert. Either way, the result is the same — new rows appear above what you selected.

Where the new rows appear and what happens to your data

New rows always insert above your selection. If you selected rows 10 through 12 and inserted 3 rows, the new rows become 10, 11, and 12. Your original rows 10, 11, and 12 shift down to become rows 13, 14, and 15. Any data in those rows moves with them.

This matters when you are inserting rows in the middle of existing data. If you want new rows at the bottom of your spreadsheet, select rows below your data instead. If your data ends at row 50 and you want 5 new rows, select rows 51 through 55, then insert. The new rows appear where you want them without disturbing anything above.

Formatting that carries over to new rows

When Excel creates new rows, it copies the formatting from the row directly above them. If row 9 has a light blue background and bold text, row 10 (the first new row) will also have a light blue background and bold text. This can save time if you want your new rows to match the rows around them.

If the formatting does not match what you need, you can change it after insertion. Select the new rows, then use the formatting tools in the toolbar to adjust colors, fonts, borders, or alignment.

Using the Insert menu instead of right-clicking

If right-clicking does not work or you prefer using the menu, you can insert rows through the top menu bar. Select your rows first, then click Insert in the menu (the exact location varies by Excel version — it may be under Home or Sheet). Look for an option that says Insert Rows Above or Insert Sheet Rows.

The result is identical to right-clicking. Use whichever method feels more natural to you.

Undoing an insertion if you made a mistake

If you inserted rows in the wrong place or inserted the wrong number, undo the action when ready. Press Ctrl+Z on Windows or Command+Z on a Mac. Excel removes the rows you just added and restores your spreadsheet to how it was before the insertion.

Undo works best right after you insert. If you have made other changes since the insertion, undoing may remove those changes too. If that happens, redo the other changes after you undo the insertion.

Frequently Asked Questions

Can I insert rows at the bottom of my spreadsheet without selecting existing rows?

Yes. Click a row number below your data, then insert. The new rows appear where you selected. You do not have to select existing rows — you can select empty rows at the bottom and insert there instead.

What if I need to insert rows in multiple different places in the same spreadsheet?

Insert them one section at a time. Select and insert rows in the first location, then select and insert rows in the second location. Each insertion is separate, so you can do as many as you need. Remember that row numbers shift after each insertion, so the location of later rows may change.

Do I have to insert rows in a block, or can I insert them scattered throughout?

You can only insert rows in a block — they must be consecutive. If you need rows in multiple separate places, insert them one section at a time. Inserting in one location does not affect rows in other locations.

Will inserting rows affect my formulas or charts?

Formulas that reference specific cells will update automatically when rows shift. If a formula refers to row 15 and you insert 5 rows above it, the formula now refers to row 20. Charts that use data from those rows will also update. Your calculations stay correct.

Can I insert rows without copying the formatting from the row above?

Excel copies formatting automatically, but you can change it after insertion. Select the new rows and clear the formatting using the toolbar, or explore different formatting. There is no option to insert rows with blank formatting during the insertion itself.