How to Insert and Add Rows in Excel

The fastest way to add a row in Excel

To add a single row, right-click on the row number where you want the new row to appear, then click Insert. Excel inserts a blank row above the row you clicked on. If you want the new row at the bottom of your data, click on the first empty row number and insert there.

You can also select a row by clicking its number on the left side, then go to the Home tab at the top, click the dropdown arrow next to Insert, and choose Insert Sheet Rows. Both methods do the same thing — the right-click method is usually faster if you only need one or two rows.

Excel always inserts rows above the row you select, never below. If you select row 5 and insert, the new row becomes row 5, and what was row 5 moves down to row 6. This matters when you're adding rows in the middle of existing data.

Key Takeaways

Right-click a row number and select Insert to add a blank row above that row in one step.
You can insert multiple rows at once by selecting several row numbers before clicking Insert.
Excel shifts all data below the inserted row down automatically — you do not need to move anything manually.
The Home tab's Insert dropdown also adds rows if you prefer using the ribbon instead of right-clicking.

Adding multiple rows at the same time

If you need to add five rows instead of one, select five row numbers before inserting. Click on the first row number you want, then hold Shift and click on the fifth row number. All five rows between them highlight in blue. Now right-click and click Insert — Excel inserts five blank rows above the first row you selected.

This is faster than inserting one row five times. It also keeps your data organized because all the new rows appear together in one block, rather than scattered through your spreadsheet.

What happens to your formulas and data when you insert rows

When you insert a row, Excel automatically adjusts any formulas that reference cells below the insertion point. If you have a SUM formula that adds rows 1 through 10, and you insert a new row in the middle, the formula updates to include the new row. You do not have to rewrite the formula yourself.

Data in the rows below the insertion point moves down, but the data itself does not change. If row 5 contained "Smith" and "500", and you insert a row above it, "Smith" and "500" are now in row 6. The values stay the same — only their position changes.

If you insert a row in the middle of a table that you created using Excel's Format as Table feature, the new row automatically becomes part of the table. You do not need to manually extend the table borders or reapply formatting.

Inserting rows at the end of your data

To add rows at the bottom of your spreadsheet, click on the first completely empty row number, then insert. If your data ends at row 50, click on row 51 and insert. The new blank row appears at row 51, and you can start typing when ready.

You can also straightforward click on an empty cell below your data and start typing — Excel does not require you to insert a row first. But if you want to insert multiple rows at the bottom in one action, the insert method is cleaner because it creates all the rows at once rather than one at a time as you type.

Using keyboard shortcuts to insert rows faster

If you use Excel frequently, keyboard shortcuts save time. Select the row number where you want to insert, then press Ctrl and the + (plus) key on your keyboard. A dialog box appears asking whether you want to insert entire rows or shift cells. Click Entire row and press Enter. The row inserts when ready.

On a Mac, use Control and = (equals) instead of Ctrl and plus. The dialog box works the same way. Once you use this shortcut a few times, it becomes faster than right-clicking, especially if you are adding rows throughout a large spreadsheet.

Removing rows you no longer need

If you insert a row by mistake or need to delete rows, right-click the row number and click Delete. Excel removes the row and shifts all rows below it up. Any formulas that referenced cells in the deleted row show an error (#REF!) unless those formulas are no longer needed.

You can delete multiple rows the same way you insert them — select several row numbers by clicking the first, holding Shift, and clicking the last. Then right-click and click Delete. All selected rows disappear at once, and the rows below shift up to fill the gap.

Frequently Asked Questions

Can I undo inserting a row if I change my mind?

Yes. Press Ctrl and Z (or Command and Z on Mac) when ready after inserting. The row disappears and your data returns to its original position. You can undo multiple times if you inserted several rows.

What if I insert a row in the middle of a formula that spans multiple rows?

Excel updates the formula automatically. If you have a SUM formula that adds rows 1 to 10, and you insert a row at row 5, the formula becomes SUM(1:11) and includes the new row. The formula adjusts itself — you do not need to edit it.

Does inserting rows change the file size of my spreadsheet?

Inserting blank rows adds very little to file size because blank cells take almost no space. However, if you insert rows and then fill them with data, the file grows proportionally to the amount of data you add. Blank rows themselves are negligible.

Can I insert rows in a protected sheet?

Not usually. If a sheet is protected, the Insert option is grayed out or disabled. The person who protected the sheet can unprotect it by going to the Review tab and clicking Unprotect Sheet. They may need to enter a password if one was set when the sheet was protected.

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.