The fastest way to delete a row

Right-click on the row number on the left side of the spreadsheet — the gray column that shows 1, 2, 3, and so on. A menu will appear. Click Delete. The row disappears, and every row below it moves up one position.

That is the complete process. The row is gone, and your data shifts automatically. If you delete row 5, what was in row 6 becomes row 5, what was in row 7 becomes row 6, and so on.

If you need to delete multiple rows at once, click on the first row number, then hold Shift and click on the last row number you want to remove. All the rows between them will highlight in blue. Right-click and select Delete, and they all vanish together.

Key Takeaways

  • Right-click the row number on the left side and select Delete to remove that row when ready.
  • Rows below the deleted row move up automatically — you do not have to shift anything yourself.
  • To delete multiple rows at once, click the first row number, hold Shift, click the last row number, then right-click and select Delete.
  • If you delete a row by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo and bring it back.
  • Deleting a row is permanent once you save the file, so double-check that you are removing the correct row before you confirm.

Why the row number matters

The row number is the gray box on the far left that contains the number itself. Clicking anywhere else in the row — on a cell with data, on the cell border, in the middle of the text — will not bring up the delete option. You must click directly on the number.

If you click on a cell instead and right-click, you will see different options like Insert or Clear Contents. Those do different things. Clear Contents erases the data inside the cell but leaves the row in place. Delete removes the entire row.

What happens to your formulas and references

If other cells in your spreadsheet contain formulas that reference the row you deleted, those formulas will update automatically. For example, if cell C10 contains the formula =SUM(C1:C9) and you delete row 5, the formula becomes =SUM(C1:C4,C6:C9) — it skips the deleted row.

If a formula directly references a cell in the row you delete — like =B5 — that formula will show an error after you delete row 5, because cell B5 no longer exists. This is a reason to check whether any other part of your spreadsheet depends on the row before you remove it.

Deleting rows versus clearing data

Deleting a row and clearing the data in a row are two different actions. When you delete a row, the row itself is gone and all rows below shift up. When you clear data, the row stays in place but becomes empty.

To clear data without deleting the row, click on the row number to select the entire row, then press Delete on your keyboard. The cells become blank, but the row number remains. To actually delete the row and remove it from the spreadsheet, you must right-click the row number and select Delete.

Use clearing when you want to keep the row structure — for example, if you have 100 rows and want to keep them all numbered 1 through 100 but remove the data from one of them. Use deletion when you want to remove the row entirely and have the remaining rows renumber themselves.

Undoing a deletion

If you delete a row by mistake, press Ctrl+Z on Windows or Cmd+Z on Mac when ready. The row will reappear with all its data intact. This works as long as you have not closed the file or performed other actions after the deletion.

Once you save the file and close it, you cannot undo the deletion. Excel keeps a history of changes only while the file is open in your current session. If you realize hours later that you deleted the wrong row, you will need to check whether your computer or cloud storage has a backup or earlier version of the file.

Deleting rows in Excel Online versus desktop Excel

The process is identical in Excel Online (the version you use in a web browser) and desktop Excel (the program you read and install). Right-click the row number and select Delete. The row disappears the same way.

One difference: in Excel Online, if you are working on a shared file, other people using the file at the same time will see your deletion appear on their screen within a few seconds. In desktop Excel, they will not see the change until you save the file and they refresh or reopen it.

Frequently Asked Questions

Can I delete a row if it contains important data?

Yes, but you should not. Excel will delete any row you tell it to delete, regardless of what data it contains. Before you delete, make sure you are removing the correct row. If you are unsure, copy the row to a different location first, or take a screenshot, so you have a record of what was there.

What if I delete a row and my spreadsheet breaks?

If formulas or other parts of your spreadsheet stopped working after you deleted a row, press Ctrl+Z (or Cmd+Z) when ready to undo. Then check which cells reference the deleted row before you delete it again. You may need to update those formulas first.

Does deleting a row delete it from the file permanently?

Once you save the file, the deletion is permanent in that saved version. However, if you have not saved yet, pressing Ctrl+Z will bring the row back. If you saved and then realized the mistake, check whether your cloud storage (OneDrive, Google Drive, Dropbox) has a version history that lets you restore an earlier version of the file.

Can I delete multiple non-consecutive rows at once?

Not in a single action. You can delete consecutive rows by selecting them together (click the first row number, hold Shift, click the last row number, then right-click and delete). To delete rows that are not next to each other, delete them one at a time, starting from the bottom and working upward. This prevents row numbers from shifting and causing you to delete the wrong rows.