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 inserts a blank row above the row you clicked on. If you right-click on row 5, the new row becomes row 5, and what was row 5 shifts down to row 6.

You can also select multiple row numbers at once to insert several rows at the same time. Click on a row number, hold Shift, and click on another row number to select a range. Right-click and choose Insert, and Excel adds as many blank rows as you selected.

On a Mac, the process is identical — right-click (or Control-click) on the row number and select Insert. The behavior and result are the same across both Windows and Mac versions of Excel.

Key Takeaways

  • Right-clicking a row number and selecting Insert adds a blank row above that row, shifting existing data down.
  • You can insert multiple rows at once by selecting several row numbers before right-clicking.
  • The Home tab in the ribbon also contains an Insert option if you prefer not to right-click.
  • Inserted rows inherit formatting from the row above them, so you may need to adjust borders, colors, or fonts afterward.

Using the Home tab in the ribbon

If you prefer using the menu instead of right-clicking, click on the row number to select it, then go to the Home tab at the top of the screen. Look for the Insert button in the toolbar — it usually appears near a dropdown arrow. Click the dropdown and select Insert Sheet Rows.

This method works the same way as right-clicking: the new row appears above the row you selected. The ribbon method is useful if you find right-clicking unreliable on your device or if you prefer keyboard navigation. Both approaches produce identical results.

What happens to your data when you insert a row

When you insert a row, all data below it moves down one row. If you have formulas that reference cells, Excel automatically updates those references. For example, if a formula in row 10 adds up cells in rows 1 through 9, and you insert a new row at row 5, the formula updates to add rows 1 through 10 instead.

The new row copies the formatting (colors, fonts, borders) from the row directly above it. If that formatting does not match what you need, you can select the new row and change it manually. Blank rows do not carry over any data, only visual formatting.

Inserting a row at the bottom of your data

If you want to add a row after your last row of data, you do not need to insert — you can simply click on the first empty cell below your data and start typing. Excel treats this as a new row automatically.

However, if you want to insert a row in the middle of existing data and push everything down, use the right-click method. Clicking below your data and typing does not shift anything; it just fills in empty space. The insert method is the only way to force existing rows to move down.

Undoing an inserted row

If you insert a row by mistake, press Ctrl+Z (or Cmd+Z on a Mac) to undo. This removes the row and restores your data to its previous position. You can undo multiple times if you inserted several rows in succession.

Undo works as long as you have not closed the file. Once you close and reopen the file, the undo history is gone, so you cannot recover an accidentally inserted row that way. Save your file only after you are certain the rows are in the right place.

Inserting rows in a filtered or sorted list

If your data is filtered (showing only certain rows) or sorted, inserting a row still works, but the new row appears in the unfiltered view at the position you selected. If you have filters active, turn them off first to see exactly where the new row will land. Click the Data tab and then Clear to remove filters temporarily.

Sorting does not prevent you from inserting rows, but inserting a row does not re-sort your data. If you insert a row in the middle of sorted data, that row stays where you put it and may break your sort order. Re-sort after inserting if you need the data in a specific order again.

Frequently Asked Questions

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

Yes. Right-click on the row number of the row below where you want the new row to go, then click Insert. The new blank row appears above it, and all data below shifts down one row. Nothing is deleted.

What if I insert a row but it goes in the wrong place?

Press Ctrl+Z (or Cmd+Z on Mac) immediately to undo. Then click on the correct row number and try again. Remember that the new row always appears above the row you right-click on.

Do inserted rows affect my formulas?

Yes, but in a good way. If a formula references a range of cells, Excel updates the range automatically when you insert a row within it. A formula that sums rows 1 through 10 will update to sum rows 1 through 11 if you insert a row in the middle.

Can I insert a row at the very top of the spreadsheet?

Yes. Right-click on row 1 and select Insert. A new row 1 appears, and all existing data shifts down. This is useful if you want to add a title or header row above your data.