Insert Multiple Rows in Excel Fast

This guide shows you how to add several blank rows to an Excel worksheet at once, saving you from the tedious click-and-repeat method. You’ll learn keyboard shortcuts, the right-click menu, and a few tricks for inserting rows in the middle of existing data without breaking anything.

What You’ll Need

Microsoft Excel (2013, 2016, 2019, 2021, or Microsoft 365)
A worksheet with existing data where you want to add rows
Basic familiarity with selecting cells or rows

Step-by-Step

Select the same number of rows you want to insert. Click on the row number (e.g., row 5) in the left margin, then drag down to select 3 rows if you need 3 new rows. Alternatively, hold Shift and press the ↓ arrow key to extend the selection downward.
Right-click any selected row number. A context menu appears.
Choose “Insert” from the menu. Excel immediately adds the same number of blank rows above your selection, shifting existing rows down. For example, selecting rows 5–7 and inserting creates three new rows at 5, 6, and 7, pushing the old data to row 8 and below.

That’s the basic method. For faster workflows, use these variations:

Use the keyboard shortcut after selecting rows: Press Ctrl + Shift + + (plus key) on Windows, or Cmd + Shift + + on Mac. This triggers the same Insert command without touching the mouse.
Insert rows without right-clicking: Select the rows, then go to the Home tab → Cells group → click the arrow under Insert → choose Insert Sheet Rows.
Insert rows at the very bottom of a table: If you’re using an Excel Table (created via Ctrl+T), simply click the last cell in the last row and press Tab. This adds a new row to the table. For a regular range, you can also select the first blank row below your data and use the same right-click method.
Insert multiple rows in the middle of a table: Select the rows where you want the new ones to appear (e.g., select rows 10–12 to insert three rows between 9 and 10). Use any of the methods above. Excel will move the selected rows down.
Insert rows using the “Insert” dialog box (older Excel): Select the rows, press Ctrl + Shift + +, and if prompted, choose “Entire row” and click OK. (In modern Excel, this dialog appears only if you have cells selected rather than whole rows.)

Common Mistakes

Selecting cells instead of whole rows: If you select only a few cells (e.g., A1:A3) and insert, Excel inserts cells, not entire rows. This shifts only the selected cells down, leaving other columns untouched, which can scramble your data.
Not selecting enough rows: If you need 5 new rows but select only 2, you get only 2 new rows. Always select exactly the number you want to add.
Inserting above the wrong row: The new rows appear above your selection. If you want rows after row 10, select row 11 (or rows 11–15 for multiple), not row 10.
Breaking merged cells: If your sheet has merged cells, inserting rows can cause errors or split the merge. Unmerge before inserting if possible.
Forgetting about formulas: When you insert rows, formulas that reference ranges may adjust automatically, but formulas with hard-coded cell references (e.g., =A1+B1) might not update as expected. Double-check any formulas near the insertion point.

Tips

Use the F4 key to repeat: After inserting rows once, press F4 to repeat the exact same insertion action. This is handy when you need to add rows in multiple places.
Use the “Insert” button on the ribbon: The Home tab’s Insert button (not the dropdown) repeats the last insert action. Clicking it directly after an insert will add rows again.
Insert rows in a table with a keyboard: In an Excel Table, select a cell in the last row, then press Tab to add a new row. To insert multiple rows at once in a table, select multiple rows in the table, right-click, and choose “Insert” – it will add that many rows above.
Use the “Insert Copied Cells” option: If you want to copy existing formatting or formulas, copy a row (Ctrl+C), right-click the row where you want new rows, and choose “Insert Copied Cells.” This inserts rows with the copied content, which you can then overwrite.
Use a macro for massive insertions: If you frequently need to insert dozens of rows, record a macro or use a simple VBA script. But for most users, the manual method is fast enough.

Troubleshooting

“Insert” option is grayed out: This usually happens when the sheet is protected. Go to Review → Unprotect Sheet (you may need the password). It can also happen if you’ve selected entire columns – make sure you’ve selected rows, not columns.
Rows are inserted but data is missing: Check if you accidentally selected cells rather than whole rows. Undo (Ctrl+Z) and try again with full row selection.
Rows are inserted but formulas show errors: If formulas reference ranges that got shifted, they might break. Check for #REF! errors and adjust the formula references manually.
Inserting rows in a table causes an error: If the table has a total row, inserting above it may be restricted. Remove the total row temporarily, insert, then re-add it.
Keyboard shortcut doesn’t work: Some keyboards require the Fn key for the plus sign. Try Ctrl + Shift + = (equals sign) as an alternative shortcut.
Rows are inserted but the formatting is inconsistent: Excel usually copies formatting from the row above. If you want consistent formatting, use “Insert Copied Cells” after copying a formatted row, or use the Format Painter afterward.

Frequently Asked Questions

How do I insert 100 rows at once?

Select rows 1 through 100 (or any starting row), then right-click and choose “Insert.” Excel will add 100 blank rows above your selection. You can also select 100 rows anywhere and use the keyboard shortcut.

Can I insert rows without messing up my formulas?

Yes, Excel automatically adjusts most formulas when you insert rows, as long as the formula references cells that shift. Just avoid hard-coded references like =A1+B1 if you need the formula to move with the data.

Why does Excel insert cells instead of rows?

Because you selected individual cells, not entire rows. To insert whole rows, click the row number(s) in the left margin to select the full row before using the Insert command.

Is there a way to insert rows in the middle of a table without breaking it?

Yes. In an Excel Table, select the same number of rows you want to add, right-click, and choose “Insert.” The table will expand, and the new rows will be part of the table.

What is the fastest way to insert multiple rows using only the keyboard?

Select the rows (click the row number, then Shift+Arrow), then press Ctrl+Shift+Plus (or Ctrl+Shift+=). That’s the quickest keyboard-only method.

Can I insert rows at the bottom of a sheet without scrolling?

Press Ctrl+Down Arrow to jump to the last row, then use the insert method. Or, if you’re using a table, just press Tab in the last cell to add a new row.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →