What you can delete in Excel, and why it matters

Excel lets you delete three different things: individual cells, entire rows, or entire columns. What you delete changes what happens to the data around it. Delete a cell and Excel asks whether to shift the remaining cells left or up. Delete a row or column and everything in it disappears, and the cells below or to the right move up or left automatically. Understanding the difference keeps you from accidentally erasing data you meant to keep.

The method you use depends on what you're trying to remove. If you want to clear the content but keep the cell structure intact, you use a different action than if you want to remove the cell itself. This matters because spreadsheets rely on position — if your formulas reference cells by location, deleting a cell can break those formulas, while clearing content leaves the structure alone.

Key Takeaways

  • Pressing Delete clears what's inside a cell but leaves the cell itself in place; right-clicking and choosing Delete removes the cell and shifts others to fill the gap.
  • Deleting a row or column removes all data in it and shifts everything below or to the right upward or leftward automatically.
  • If your spreadsheet uses formulas that reference cells by location, deleting cells can break those formulas — clearing content instead is often safer.
  • You can undo any deletion by pressing Ctrl+Z when ready after, so experiment without fear if you're unsure what will happen.

How to clear the contents of a cell without removing the cell itself

The simplest deletion is clearing what's inside a cell while leaving the cell in place. Click the cell you want to clear, then press the Delete key. The content disappears, but the cell stays where it is, and nothing shifts. This is what you want when you have a spreadsheet with a set structure — like a budget template or a form — and you just want to erase old numbers and start fresh.

If you want to clear multiple cells at once, click the first cell, then hold Shift and click the last cell in the range you want to clear. All cells between them will be highlighted. Press Delete, and all the content in that range disappears at once. You can also click and drag to select a rectangle of cells, then press Delete.

How to delete a single cell and shift the others

When you want to remove a cell entirely — not just its contents — right-click on it and choose Delete from the menu. A dialog box appears asking which direction you want the remaining cells to move: left or up. Choose the direction that makes sense for your data. If you're deleting a cell in the middle of a row of numbers, you probably want the cells to the right to shift left. If you're deleting a cell in the middle of a column, you probably want the cells below to shift up.

You can also select multiple cells and delete them all at once. Click the first cell, hold Shift, and click the last cell in the range. Right-click and choose Delete. The dialog will ask which direction to shift, and all the cells in that range will be removed together. This is useful when you have a gap in your data that you want to close up.

How to delete an entire row

To delete a whole row, click the row number on the left side of the spreadsheet. The entire row will highlight in blue. Right-click and choose Delete. The row disappears, and every row below it shifts up by one. All the data in that row is gone.

You can delete multiple rows at once by clicking the first row number, holding Shift, and clicking the last row number you want to delete. All rows between them will highlight. Right-click and choose Delete, and they all disappear together. This is faster than deleting rows one at a time when you need to remove a large block.

How to delete an entire column

To delete a whole column, click the column letter at the top of the spreadsheet. The entire column will highlight in blue. Right-click and choose Delete. The column disappears, and every column to the right shifts left by one. All the data in that column is gone.

You can delete multiple columns at once by clicking the first column letter, holding Shift, and clicking the last column letter you want to delete. All columns between them will highlight. Right-click and choose Delete, and they all disappear together. This works the same way as deleting multiple rows.

What happens to formulas when you delete cells

If your spreadsheet contains formulas that reference cells by their location — like =A1+B1 — deleting one of those cells will break the formula. Excel will show an error like #REF! in the cell that contained the formula. This is why it's important to think before you delete: if you're not sure whether a cell is referenced by a formula somewhere else, it's safer to clear the content instead of deleting the cell itself.

If you delete a row or column that contains cells referenced by formulas, those formulas will also break. Before you delete a large section of your spreadsheet, scan it for formulas and think about whether they depend on the cells you're about to remove. If you're unsure, use Ctrl+Z to undo the deletion when ready after you realize the problem.

How to undo a deletion

If you delete something by mistake, press Ctrl+Z on Windows or Command+Z on a Mac. Excel will undo the last action and restore what you deleted. You can press Ctrl+Z multiple times to undo several actions in a row, stepping backward through what you've done. This works for any deletion — cells, rows, or columns.

Undo only works while you're in the same session. Once you close the file without saving, you cannot undo deletions from before you closed it. If you're about to delete something large and you're not completely sure it's safe, save your file first. That way, if something goes wrong, you can close without saving and reopen the file to get back to where you started.

Frequently Asked Questions

What's the difference between Delete and Clear?

Delete removes the cell itself and shifts other cells to fill the gap. Clear removes only what's inside the cell, leaving the cell in place. Press Delete to clear content. Right-click and choose Delete to remove the cell itself.

If I delete a row, do the formulas in other rows break?

Only if those formulas reference cells in the row you deleted. If a formula in row 5 adds up numbers in row 3, and you delete row 3, the formula will show #REF! error. If the formula doesn't reference anything in the deleted row, it will keep working normally.

Can I delete multiple non-adjacent rows at once?

Yes. Click the first row number, then hold Ctrl and click each additional row number you want to delete. All selected rows will highlight. Right-click and choose Delete, and they all disappear together.

What if I delete a column by mistake?

Press Ctrl+Z when ready to undo. The column will come back with all its data intact. You can undo multiple times to step backward through your recent actions.