The fastest way to add multiple rows at once

To add multiple rows in Excel, right-click on the row number where you want the new rows to appear, then select Insert. Excel will add one row. To add more than one at a time, first select as many rows as you want to insert — click on a row number, hold Shift, and click on another row number further down. Then right-click and select Insert. Excel adds that many rows all at once.

The rows appear above the row you selected. If you want 5 new rows starting at row 10, select rows 10 through 14, right-click, and choose Insert. Excel pushes the old rows 10 through 14 down and fills the space with blank rows.

You can also use the menu: select your rows, go to Home tab, find the Insert button in the Cells group, click the small arrow next to it, and choose Insert Sheet Rows. The result is the same either way.

Key Takeaways

  • Select as many row numbers as you want to add, then right-click and choose Insert to add them all at once above your selection.
  • Existing rows move down automatically, so your data stays intact and nothing overwrites.
  • You can insert rows at the top, middle, or bottom of your spreadsheet using the same method.
  • If you need to add rows regularly, consider using a template with blank rows already built in so you only fill them as needed.

Selecting multiple rows the right way

The selection step matters because Excel counts how many rows you selected and inserts exactly that many. If you select 3 rows and insert, you get 3 new rows. If you select 10 rows and insert, you get 10 new rows.

To select rows correctly, click on the row number on the left side of the spreadsheet (not a cell inside the row). The entire row highlights in blue. Then hold Shift and click on another row number further down. All rows between them highlight. You can also hold Ctrl and click individual row numbers if you want to select rows that are not next to each other, but inserting works best when your selected rows are consecutive.

If you accidentally select the wrong rows, click somewhere else to deselect, and start over. There is no penalty for trying again.

Where the new rows appear

Excel always inserts new rows above your selection. This matters when you are deciding where to click. If you want new rows to appear between row 5 and row 6, select row 6 and insert. The new rows land in row 6, pushing the old row 6 down.

If you want new rows at the very bottom of your data, click on the first empty row below your data, select as many empty rows as you need, and insert. The new rows appear there, and you can start typing.

If you want new rows at the very top, select row 1, then insert. Your headers or existing data move down, and the new rows appear at the top.

Inserting rows without losing data

When you insert rows, Excel moves everything that was in those rows down automatically. Your formulas, formatting, and data all shift together. Nothing gets deleted unless you specifically delete it.

If you have a formula in row 10 that adds up rows 1 through 9, and you insert 5 new rows at row 5, the formula moves to row 15 and now adds rows 1 through 14. Excel updates the formula for you. This is one reason inserting is safer than copying and pasting — you do not have to fix references by hand.

The one exception: if you have data in columns to the right that is not part of your main table, inserting rows might push it out of alignment. Check your full spreadsheet before inserting if you have data in unexpected places.

Adding rows in the middle of a table

If your spreadsheet is a table (created with Format as Table or Insert Table), inserting rows works slightly differently. Click inside the table, then right-click on a row number and select Insert. Excel adds the row inside the table and keeps the table formatting — borders, colors, and filter buttons all stay consistent.

If you try to insert a row outside the table, Excel asks whether you want to insert inside the table or outside it. Choose Insert Table Rows Above to keep the row part of the table. This matters if you use filters or sorting, because rows outside the table will not be included.

Tables are useful when you add rows regularly, because the formatting applies automatically to new rows. You do not have to copy the format from the row above.

Keyboard shortcut for faster inserting

If you insert rows often, the keyboard shortcut is faster than right-clicking. Select your rows, then press Ctrl + Plus (the plus key on the main keyboard, not the numpad). A dialog box appears asking whether you want to insert entire rows, entire columns, or shift cells. Choose Entire row and click OK.

On a Mac, the shortcut is Control + Plus. The dialog works the same way.

After you use the shortcut a few times, it becomes automatic. Many people who insert rows regularly use the shortcut instead of the menu because it saves a few seconds each time.

Undoing a mistake

If you insert rows and realize you made a mistake, press Ctrl + Z (or Command + Z on Mac) when ready. Excel removes the rows and puts everything back where it was. You can undo multiple times if you need to go back several steps.

If you inserted rows, worked for a while, and then realized the mistake, undo still works — it goes back to the state before you inserted, even if you have done other things since. However, if you close the file and reopen it, undo is no longer available. Save your file only after you are sure the rows are in the right place.

Frequently Asked Questions

Can I add rows in the middle of a formula without breaking it?

Yes. When you insert rows, Excel updates formulas automatically. If a formula adds rows 1 through 10 and you insert 3 rows at row 5, the formula now adds rows 1 through 13. The formula adjusts itself, so you do not have to fix it by hand.

What happens to my data when I insert rows?

Data below the insertion point moves down. Data above stays in place. Nothing is deleted unless you delete it yourself. Formatting, colors, and formulas all move with the data.

Can I insert rows at the bottom without selecting empty rows?

Yes. Click on the last row with data, then press Ctrl + Plus and choose Entire row. A new row appears below. You can repeat this as many times as you need, or select multiple rows and insert them all at once.

Do I need to insert rows or can I just type in empty rows?

If empty rows already exist below your data, you can just click and type. Inserting is only necessary if you need to add rows in the middle of existing data or if you want to push data down to make space.

What is the difference between inserting rows and copying rows?

Inserting creates blank rows and pushes existing data down. Copying duplicates a row's content and formatting but does not move anything. Use insert when you need space; use copy when you want to repeat a row's format or content.