The fastest way to add a row

Right-click on the row number where you want the new row to appear, then click Insert. Excel adds a blank row above the one you clicked, and shifts everything below it down one row. This takes three seconds and works the same way whether you're using Excel on Windows, Mac, or the web version.

If you need to add multiple rows at once, click on the first row number, then hold Shift and click on the last row number to select them all. Right-click and choose Insert — Excel adds that many blank rows above your selection.

Key Takeaways

  • Right-click a row number and select Insert to add a blank row above it in one step.
  • Select multiple row numbers at once to insert several blank rows in the same location.
  • Inserting a row pushes all data below it downward, so your existing data stays intact.
  • You can undo an inserted row immediately by pressing Ctrl+Z (Windows) or Command+Z (Mac) if you change your mind.

Using the menu instead of right-clicking

If right-clicking doesn't work on your device or you prefer the menu, click on the row number to select the entire row, then go to the Home tab at the top. Look for the Insert button in the toolbar — it usually has a small arrow next to it. Click the arrow and choose Insert Sheet Rows.

On Excel for Mac, the button location is the same. On the web version of Excel, the Insert button appears in the same place, though the toolbar layout is slightly more compact.

What happens to your data when you insert a row

When you insert a row, everything below it moves down exactly one row. If you had data in row 5 and you insert a new row at row 3, that data in row 5 is now in row 6. Formulas that reference cells in those rows update automatically — Excel adjusts the cell references so your calculations stay correct.

The new row you insert is always completely blank. It doesn't copy formatting or formulas from nearby rows, so you'll need to add those yourself if you want them.

Inserting a row at the very end of your data

If you want to add a row after your last row of data, you don't have to insert — you can just click on the first empty cell below your data and start typing. Excel treats that as a new row automatically. This is faster than inserting when you're adding data to the bottom of a list.

If you do want to insert a row at the end instead, click on the row number of the first completely empty row below your data, right-click, and choose Insert. The new row appears above the one you clicked.

Inserting a row in the middle of a table

If your data is formatted as an Excel table (with the table design tools visible), inserting a row works the same way — right-click the row number and choose Insert. The new row becomes part of the table automatically and inherits the table's formatting and any formulas that were in the rows above and below it.

Tables in Excel are useful because they handle this for you. If you haven't formatted your data as a table yet and you're planning to add rows often, converting it to a table saves time. Select any cell in your data, go to the Home tab, click Format as Table, and choose a style.

Fixing mistakes when you insert the wrong row

If you inserted a row in the wrong place, press Ctrl+Z (Windows) or Command+Z (Mac) immediately to undo it. This works as long as you haven't made other changes since the insert. If you've already made changes and want to remove the row you inserted, right-click the row number and choose Delete instead.

Be careful with Delete — it removes the row and shifts everything below it up. This is the opposite of Insert. If you delete by accident, undo with Ctrl+Z or Command+Z right away.

Inserting rows in Excel on your phone or tablet

On the Excel mobile app for iPhone or Android, tap and hold on the row number until a menu appears, then tap Insert. The process is the same as on desktop — the new row appears above the one you tapped.

If the menu doesn't appear, make sure you're tapping directly on the row number itself, not on a cell. The row number is the gray area on the left side of the spreadsheet where the numbers 1, 2, 3 appear.

Frequently Asked Questions

Can I insert a row between two specific rows without losing data?

Yes. Right-click the row number of the row below where you want the new row to go, then click Insert. Everything below that point moves down one row, and your data stays intact. The new row is blank, so you add your data to it afterward.

What's the difference between Insert and Delete?

Insert adds a new blank row and pushes everything below it down. Delete removes a row and pulls everything below it up. They are opposites. If you delete by accident, press Ctrl+Z or Command+Z to undo immediately.

Do formulas update automatically when I insert a row?

Yes. If a formula references cells below the row you insert, Excel updates those cell references automatically so the formula still works. For example, if a formula says =SUM(A1:A10) and you insert a row in the middle, it becomes =SUM(A1:A11).

Can I insert a row without right-clicking?

Yes. Click the row number to select the entire row, then go to the Home tab and click the Insert button in the toolbar. You can also use the menu: click Sheet, then Insert Sheet Rows (the exact menu names vary slightly by version).

What if I need to add 50 rows at once?

Click on the first row number, hold Shift, and click on the 50th row number below it to select all 50 rows. Right-click and choose Insert. Excel adds 50 blank rows above your selection in one step.