The fastest way to add a row is right-click and insert

To add a new row in Excel, right-click on the row number where you want the new row to appear, then click Insert. Excel will push everything below that row down by one and leave the new row empty. If you want the new row at the very bottom of your data, you can also just click on an empty cell below your last entry and start typing — Excel will treat it as a new row automatically.

The row you right-click on is the row that will move down. So if you right-click on row 5, a new blank row 5 appears, and what was row 5 becomes row 6. This matters when you're inserting in the middle of existing data.

You can insert multiple rows at once by selecting several row numbers before you right-click. Click on row 3, then hold Shift and click on row 5 to select rows 3, 4, and 5 together. Right-click and insert, and Excel will add three new blank rows in that space.

Key Takeaways

  • Right-click the row number where you want the new row to go, then click Insert — the selected row moves down and a blank row takes its place.
  • Select multiple row numbers at once (using Shift+click) to insert several blank rows in one action.
  • Inserting a row does not delete anything — it pushes existing data down, so you keep all your information.
  • If you insert a row in the middle of a formula, Excel automatically adjusts the formula to reference the new row numbers.

Using the menu instead of right-click

If right-clicking does not work on your device or you prefer the menu, go to the Home tab at the top of Excel. Look for the button labeled Insert (it usually has a small dropdown arrow next to it). Click the arrow and select Insert Sheet Rows Above. This inserts a row above whichever row your cursor is currently in.

The menu method works the same way as right-clicking — the row your cursor is on moves down, and a blank row appears in its place. Some people find the menu easier to see and understand, especially if they are new to spreadsheets.

What happens to formulas when you insert a row

If you insert a row in the middle of data that contains formulas, Excel updates those formulas automatically. For example, if you have a formula in row 10 that adds up rows 3 through 9, and you insert a new row 5, the formula changes to add rows 3 through 10 instead. Excel knows to include the new row in the calculation.

This automatic adjustment is one reason inserting rows is safer than deleting and re-entering data. You do not have to hunt through your spreadsheet and fix formulas by hand — Excel does it for you.

Inserting a row at the beginning or end of your data

To add a row at the very top of your spreadsheet, right-click on row 1 and insert. Everything shifts down, and you get a blank row 1. This is useful if you want to add a title or header row later.

To add a row at the bottom, click on an empty cell below your last row of data and start typing. Excel treats it as a new row automatically — you do not need to right-click or use the menu. This is the fastest method when you are adding data to the end of an existing list.

Undoing an accidental insertion

If you insert a row by mistake, press Ctrl+Z (or Cmd+Z on a Mac) when ready to undo it. Excel will remove the blank row and restore your data to its previous state. You can undo multiple actions in a row by pressing Ctrl+Z several times.

If you have already done other work after inserting the row, undo will reverse all of it, not just the insertion. In that case, you can delete the row manually instead: right-click the row number and click Delete. This removes only that row without undoing your other changes.

Inserting rows in a filtered or sorted spreadsheet

If you have filtered your data (so only certain rows are visible) or sorted it, inserting a row can be confusing because you might not see where it goes. The safest approach is to remove the filter or sort first, insert your row, then reapply the filter or sort. This way you can see exactly where the new row appears.

To remove a filter, click the Data tab and then click Clear. To undo a sort, press Ctrl+Z. Once you have inserted your row, you can sort or filter again the same way you did before.

Frequently Asked Questions

Does inserting a row delete anything?

No. Inserting a row pushes everything below it down by one row. All your data stays in the spreadsheet — it just moves to a new location. Nothing is removed unless you specifically delete a row.

Can I insert a row between two cells in the same row?

No. Excel inserts entire rows, not individual cells. If you want to add a column instead, right-click on a column letter and click Insert. Rows run left to right; columns run top to bottom.

What if I insert a row and my data looks wrong?

Press Ctrl+Z to undo the insertion and see your data as it was. Then check whether you right-clicked on the correct row number. Remember: the row you right-click on is the row that moves down, not the row above where the new row appears.

Can I insert a row in the middle of a table or named range?

Yes. If your data is part of a table (created with the Table button on the Insert tab), inserting a row adds it to the table automatically. If you have named a range of cells, inserting a row inside that range expands the range to include the new row.