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. If you want the row below instead, right-click the row number of the one below where you want to insert, then insert above it.

The row number is the gray box on the left edge of the spreadsheet that shows 1, 2, 3, and so on. When you right-click it, a small menu appears with the Insert option near the top.

If you need to add multiple rows at once, click the first row number, then hold Shift and click the last row number of the range you want. Right-click anywhere in that highlighted section and click Insert. Excel adds as many new rows as you selected, all at once.

Key Takeaways

  • Right-click a row number and select Insert to add a single blank row above it.
  • Select multiple row numbers by clicking the first, holding Shift, and clicking the last, then right-click and Insert to add that many rows at once.
  • The new rows appear above the row you right-clicked, not below it.
  • Inserting a row shifts all data below it downward and preserves formulas that reference cells in those rows.

Adding rows using the menu instead of right-click

If right-clicking does not work on your device or you prefer the menu, click the row number to select the entire row, then go to the Home tab at the top. Look for a button that says Insert with a small dropdown arrow next to it. Click the arrow and select Insert Sheet Rows.

This method does the same thing as right-clicking but takes more steps. Most people find right-clicking faster once they know where to look.

What happens to your data when you insert a row

When you insert a row, everything below it moves down one row. If you had data in row 5 and you insert a row at row 3, that data moves to row 6. The new row 3 is blank and ready for you to type in.

If you have formulas that add up a range of cells — for example, a formula that says =SUM(A1:A10) — and you insert a new row in the middle of that range, Excel automatically updates the formula to include the new row. So if you insert a row between A5 and A6, the formula becomes =SUM(A1:A11). This usually saves you from having to fix formulas by hand.

Adding a row at the very end of your data

If you want to add a row after all your existing data, you do not need to insert. Just click the first empty cell below your data and start typing. Excel treats it as a new row automatically.

Inserting is useful when you need the new row in the middle of existing data. Adding at the end is faster because you skip the right-click step entirely.

Undoing a row you added by mistake

If you inserted a row and then realized you did not want it, press Ctrl+Z on Windows or Command+Z on Mac. This undoes the insert and brings back any data that was below it. You can undo multiple times if you need to go back several steps.

Undo works when ready after you insert. If you close the file and reopen it, you cannot undo anymore, so use Ctrl+Z or Command+Z right away if you make a mistake.

Inserting rows in a table instead of a regular range

If your data is formatted as an Excel table — a special format with a header row and colored formatting — inserting works slightly differently. Right-click a row number inside the table and click Insert. The new row appears inside the table, not outside it, and the table automatically expands to include it.

Tables are useful because they keep your data organized and make formulas easier to write. If you are not sure whether your data is a table, look for a colored header row and a filter button (a small down arrow) in the first row. If you see those, it is a table.

Frequently Asked Questions

Can I insert a row between the header and the data?

Yes. Right-click the row number of the first data row (the one below your headers) and click Insert. The new blank row appears between the header and your data. You can then type new data into it or leave it blank if you need a visual break.

What if I want to add a row at the very top of the sheet?

Right-click row number 1 and click Insert. A new row 1 appears, and everything else shifts down. Your original row 1 becomes row 2.

Does inserting a row delete anything?

No. Inserting pushes existing rows down but does not delete them. Everything that was in your spreadsheet stays there, just one row lower. If you want to remove rows instead, right-click and select Delete, which is the opposite action.

Can I insert a row on my phone or tablet?

Excel on phones and tablets has limited features. You can usually add data to empty rows at the bottom, but inserting rows in the middle is difficult or impossible on mobile. Use the desktop version of Excel or a web browser if you need to insert rows regularly.