The fastest way to remove 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 all rows below it move up one position.

That is the complete process. Excel does not ask you to confirm or warn you that the action cannot be undone — it straightforward removes the row. If you delete the wrong row by accident, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo.

The row number itself does not matter. Whether you delete row 5 or row 500, the steps are identical.

Key Takeaways

  • Right-click the row number on the left side and select Delete to remove that entire row in one action.
  • All rows below the deleted row shift up automatically — you do not need to move them yourself.
  • Pressing Ctrl+Z (or Cmd+Z on Mac) when ready after deletion will undo the action if you removed the wrong row.
  • Deleting a row removes all data in that row across every column, so double-check the row number before you delete.
  • You can delete multiple rows at once by clicking the first row number, holding Shift, and clicking the last row number, then right-clicking and selecting Delete.

Deleting multiple rows at the same time

If you need to remove several rows that are next to each other, you can delete them all in one action instead of one at a time. Click the row number of the first row you want to delete. Then hold down the Shift key on your keyboard and click the row number of the last row you want to delete. All rows between them will highlight in blue.

Right-click any of the highlighted row numbers and select Delete. All the selected rows disappear at once, and the rows below them move up. This method is much faster than deleting rows one by one, especially if you have ten or twenty rows to remove.

If the rows you want to delete are not next to each other — for example, you want to delete row 3, row 7, and row 12 — click the first row number, then hold Ctrl (or Cmd on Mac) and click each additional row number. Right-click and select Delete. All non-consecutive rows will be removed.

What happens to your data when you delete a row

When you delete a row, every piece of data in that row is gone permanently. If row 5 contains a customer name, phone number, and address, all three pieces of information disappear. The row below it (row 6) becomes the new row 5.

This is different from clearing the contents of a row. If you want to keep the row but remove only the data inside it, right-click the row number and select Clear Contents instead of Delete. The empty row will remain in place, and all other rows stay where they are.

Formulas that reference a deleted row will show an error. For example, if cell C10 contains the formula =SUM(C5:C9) and you delete row 7, the formula will still work because it sums the remaining cells. But if you delete row 5 and the formula references only that row, it will display #REF! error.

Using the Edit menu instead of right-clicking

If right-clicking does not work on your computer or you prefer using the menu, you can delete a row through the Edit menu at the top of the screen. First, click the row number to select the entire row. Then click Edit in the menu bar, find Delete, and click it.

On some versions of Excel, the Delete option may be under a different menu name or may require you to click Sheet instead of Edit. The right-click method is faster and works the same way on all versions, so that is the approach most people use.

Recovering a deleted row

If you delete a row and realize when ready that it was the wrong one, press Ctrl+Z (Windows) or Cmd+Z (Mac). This undoes the deletion and brings the row back exactly as it was. You can undo multiple deletions by pressing the keyboard shortcut several times in a row.

Undo works only if you have not closed the file since the deletion. Once you close Excel and reopen the file, the deleted row is gone permanently and cannot be recovered through undo. If you are working with important data, save a backup copy of your spreadsheet before you start deleting rows.

Deleting blank rows to clean up your spreadsheet

Spreadsheets sometimes contain empty rows between sections of data. These blank rows take up space and can make the spreadsheet harder to read. You can delete them the same way you delete any other row — right-click the row number and select Delete.

If your spreadsheet has many blank rows scattered throughout, deleting them one at a time is slow. Instead, you can sort your data to move all blank rows to the bottom, then select and delete them all at once. Click any cell in your data, then click Data in the menu bar and select Sort. Excel will organize your data and push empty rows to the end, where you can select and delete them together.

When to delete a row versus clearing its contents

Deleting a row removes it completely and shifts all rows below it upward. Clearing the contents of a row removes only the data inside it and leaves the empty row in place. Choose the right action based on what you are trying to accomplish.

Delete a row if you want to remove it from the spreadsheet entirely and do not need the empty space. Clear the contents if you want to keep the row structure the same but remove the data — this is useful if you have formulas or formatting that depend on specific row numbers staying in place.

For example, if row 10 contains a total formula that adds up rows 1 through 9, deleting one of those rows will change the sum. If you clear the contents of a row instead, the formula will still work and straightforward treat that row as zero.

Frequently Asked Questions

Can I delete a row if it contains a formula?

Yes. Deleting a row that contains a formula removes that formula. If other cells reference that formula, they will show a #REF! error. If you are not sure whether the row is safe to delete, undo the deletion when ready and check what other cells depend on it.

What is the difference between deleting a row and hiding a row?

Deleting removes the row completely and shifts all rows below it up. Hiding keeps the row in place but makes it invisible — you can unhide it later. To hide a row instead of deleting it, right-click the row number and select Hide. Hidden rows are useful when you want to temporarily remove data from view without losing it.

Does deleting a row affect my column headers?

Only if your header row is the one you delete. If your headers are in row 1 and you delete row 5, the headers stay in place. Be careful not to accidentally delete row 1 if it contains your column names.

Can I delete the first row or the last row?

Yes. You can delete any row in the spreadsheet, including row 1 and the last row with data. Excel will adjust the remaining rows accordingly. There is no special protection on the first or last row.

What happens if I delete a row that is part of a table?

If your data is formatted as an Excel table, deleting a row from inside the table will remove that row from the table structure. The table will automatically resize to exclude the deleted row. If you delete a row outside the table, the table is not affected.