What happens when you delete a cell in Excel

Deleting a cell in Excel is not the same as clearing what is inside it. When you delete a cell, Excel removes the cell itself and shifts the remaining cells to fill the gap — either up or to the left, depending on which direction you choose. When you clear a cell, you erase only the content and leave the cell structure in place.

This distinction matters because deleting cells can break formulas that reference nearby cells, or it can accidentally rearrange data you meant to keep aligned. Most of the time, clearing a cell (removing just the content) is what you actually want to do.

Key Takeaways

  • Deleting a cell removes the cell itself and shifts other cells to fill the space, while clearing a cell removes only the content inside it.
  • To clear a cell without deleting it, select the cell and press Delete, or right-click and choose Clear Contents.
  • To delete an entire cell and shift others, right-click and choose Delete, then specify whether to shift cells up or left.
  • Deleting cells can break formulas in other cells that reference the deleted cell, so check your spreadsheet after deleting.
  • Use Undo (Ctrl+Z on Windows, Command+Z on Mac) when ready if a deletion breaks something you did not intend.

How to clear the contents of a cell

If you want to remove what is inside a cell but keep the cell itself in place, select the cell and press the Delete key. This erases the content — text, numbers, or formulas — and leaves an empty cell in the same location. Other cells do not move.

You can also right-click the cell, and a menu will appear. Click Clear Contents to remove what is inside. This method works the same way as pressing Delete and is useful if you are clearing multiple cells at once — select all of them first, then right-click and choose Clear Contents.

How to delete an entire cell and shift others

To delete a cell itself (not just its contents), right-click on the cell and select Delete from the menu. A dialog box will appear asking which direction to shift the remaining cells. Choose Shift cells up if you want cells below to move up and fill the gap, or Shift cells left if you want cells to the right to move left.

You can also delete an entire row or column this way. Right-click on the row number (on the left side) or column letter (at the top), and select Delete. The entire row or column will be removed, and all cells will shift accordingly.

Deleting cells and what it does to formulas

If other cells contain formulas that reference a cell you delete, those formulas will break. For example, if cell C1 contains the formula =A1+B1 and you delete cell A1, the formula in C1 will show an error (usually #REF!) because it no longer has a cell to reference.

Before you delete a cell, scan the spreadsheet to see if any formulas depend on it. If you are unsure, use Undo (Ctrl+Z on Windows, Command+Z on Mac) right after deleting to restore the cell and the formulas that relied on it. This is the fastest way to fix an accidental deletion.

Deleting multiple cells at once

To delete several cells together, click on the first cell, then hold Shift and click on the last cell you want to delete. This selects a range. Right-click and choose Delete, then specify whether to shift cells up or left. All the selected cells will be deleted at once.

You can also select cells that are not next to each other by holding Ctrl (or Command on Mac) and clicking each cell individually. Then right-click and delete them together. Excel will shift cells to fill the gaps in the order you specified.

When to delete versus when to clear

Clear a cell when you want to remove data but keep your spreadsheet structure intact — for instance, if you have a table with headers and you want to erase one entry without moving anything else. Clearing is safer because it does not affect formulas or the alignment of your data.

Delete a cell when you are removing an entire row or column of data, or when you are consolidating a list and want to remove gaps. Deleting is more aggressive and should be done carefully, especially in spreadsheets with formulas. If you are new to Excel, clearing is usually the right choice.

Undoing a deletion you did not mean to do

If you delete a cell and when ready realize it was a mistake, press Ctrl+Z (on Windows) or Command+Z (on Mac) to undo the deletion. Excel will restore the cell and any formulas that depended on it. You can undo multiple actions in a row by pressing the shortcut repeatedly.

If you have already saved the file after deleting, you cannot undo the deletion. For this reason, it is a good habit to save your spreadsheet only after you are confident your changes are correct. If you work on important spreadsheets, consider saving a backup copy before making large deletions.

Frequently Asked Questions

What is the difference between Delete and Clear Contents?

Delete removes the cell itself and shifts other cells to fill the space. Clear Contents removes only what is inside the cell and leaves the cell in place. Use Clear Contents most of the time unless you specifically want to remove the cell structure.

Will deleting a cell break my formulas?

Yes, if another cell has a formula that references the cell you delete, that formula will show an error. Check for formulas before deleting, or use Undo when ready if something breaks.

Can I delete a cell without shifting others?

No, deleting a cell always shifts other cells to fill the gap. If you want to remove content without shifting anything, use Clear Contents instead.

How do I delete an entire row or column?

Right-click on the row number (left side) or column letter (top), then select Delete. The entire row or column will be removed and all cells will shift accordingly.

Can I undo a deletion after I save the file?

No, once you save the file, you cannot undo changes from before the save. Save your spreadsheet only after you are sure your deletions are correct, or keep a backup copy.