The fastest way to remove a row or column

Right-click on the row number or column letter you want to remove. A menu appears. Click "Delete" and the row or column vanishes when ready. Everything below or to the right shifts up or left to fill the space. This works the same way in Excel on Windows, Mac, and in Excel Online through a web browser.

If you need to delete multiple rows or columns at once, click the first one, then hold Shift and click the last one. All the rows or columns between them highlight together. Right-click and select "Delete" — they all disappear in one action.

Key Takeaways

  • Right-click the row number or column letter, then click Delete to remove it when ready.
  • Hold Shift and click to select multiple rows or columns before deleting them together.
  • Deleted rows and columns cannot be recovered after you close the file without saving, so use Undo (Ctrl+Z or Cmd+Z) when ready if you delete by mistake.
  • Clearing the contents of a row (selecting it and pressing Delete) leaves the empty row in place, which is different from deleting the row itself.
  • Excel Online and desktop Excel work the same way for this task, though the right-click menu may look slightly different.

The difference between deleting and clearing

Deleting a row or column removes it from the spreadsheet entirely. The rows or columns below or to the right shift to fill the gap. If you had row 5 and deleted it, row 6 becomes the new row 5.

Clearing a row or column is different. You select the row or column, press Delete on your keyboard, and the contents disappear — but the empty row or column stays in place. The numbering does not change. Use clearing when you want to erase data but keep the structure of your spreadsheet the same. Use deleting when you want to remove the row or column itself.

How to undo a deletion you did not mean to make

If you delete a row or column by mistake, press Ctrl+Z on Windows or Cmd+Z on Mac when ready. The deleted row or column reappears with all its data intact. This works as long as you have not closed the file.

Once you close the file without saving, the deletion is permanent. If you closed the file and saved it after the deletion, the undo history is gone. For this reason, it is safer to close without saving if you realize you deleted something important and have not yet saved the file.

Deleting rows or columns in the middle of your data

When you delete a row or column in the middle of your spreadsheet, everything shifts. If you had formulas that referenced cells in the deleted row or column, those formulas break and show an error like #REF!. Before you delete, check whether any other cells depend on the data you are about to remove.

You can see which cells reference a particular cell by clicking on it and looking at the formula bar at the top. If the cell contains a formula, you will see what it references. If you are unsure, use Undo after the deletion to restore it while you check.

Deleting rows or columns in Excel Online

Excel Online works the same way as the desktop version. Right-click the row number or column letter and select Delete from the menu. The row or column disappears and everything shifts. Undo works the same way — press Ctrl+Z or Cmd+Z to bring it back.

One difference: Excel Online saves your changes automatically as you work, so you cannot recover a deletion by closing without saving the way you can in desktop Excel. If you delete something by mistake in Excel Online, undo when ready.

Selecting and deleting non-consecutive rows or columns

If the rows or columns you want to delete are not next to each other, you can still delete them together. Click the first row or column number, then hold Ctrl (Windows) or Cmd (Mac) and click each additional row or column you want to remove. They all highlight in blue. Right-click and select Delete, and all of them disappear at once.

This is faster than deleting them one at a time, especially if you have many scattered rows or columns to remove. The remaining rows and columns shift to fill the gaps after each deletion.

What happens to your data when you delete a row

When you delete a row, all the data in that row is gone. The rows below it move up. If you had 100 rows of data and deleted row 50, you now have 99 rows, and what was row 51 is now row 50.

If your spreadsheet has headers in the first row (like "Name", "Email", "Phone"), deleting a data row does not affect the headers. Only the data rows shift. This is why it is common to freeze the header row so it stays visible when you scroll — that way you always know what each column contains, even after you delete rows below it.

Frequently Asked Questions

Can I delete a row without losing the data?

Not with the Delete command — that removes the row and its data permanently. If you want to keep the data, copy the row to another location first, then delete it. Or clear the contents instead of deleting the row itself by selecting it and pressing Delete.

What if I delete a row and my formulas break?

Press Ctrl+Z or Cmd+Z when ready to undo the deletion and restore the row. Then check which cells contain formulas that reference the row you wanted to delete. You may need to rewrite those formulas to reference different cells, or move the data instead of deleting it.

Does deleting a row delete the entire row across all sheets?

No. Each sheet in an Excel workbook is separate. Deleting a row only affects the sheet you are currently on. Other sheets keep their rows intact. If you need to delete the same row from multiple sheets, you have to do it on each sheet individually.

Can I delete a row by selecting cells instead of the row number?

You can select cells and clear their contents, but that is not the same as deleting the row. To delete the entire row, you must click the row number on the left side. Then right-click and select Delete. Selecting individual cells and deleting them only clears those cells — the row stays in place.