What happens when you delete a cell in Sheets

When you delete a cell in Google Sheets, the program does not straightforward erase what is in that cell — it shifts the cells around it to fill the gap. If you delete a cell in the middle of a row, the cells to the right move left. If you delete a cell in the middle of a column, the cells below move up. This matters because formulas that reference those cells will break, and you might accidentally overwrite data you meant to keep.

The safest approach is to clear the contents of a cell without deleting the cell itself. This leaves the cell in place so formulas and formatting stay intact, and nothing shifts. You have three main choices: clear just the data, clear the data and formatting, or delete the entire cell and let Sheets reorganize what is around it.

Key Takeaways

  • Clearing a cell (removing its contents) is safer than deleting it, because the cell stays in place and formulas do not break.
  • Use Edit > Clear Values to remove only the data, or Clear All to remove data and formatting at the same time.
  • Delete a cell only when you want Sheets to shift the surrounding cells left or up to fill the gap.
  • Right-click on a cell or range and choose Delete Cells to choose whether to shift left or shift up.
  • If you delete a cell by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo.

Clear the contents without moving anything

Clearing a cell removes what is inside it but leaves the cell where it is. This is the right choice most of the time, because your spreadsheet structure stays the same and any formulas that point to that cell will not break.

Select the cell or cells you want to clear. Then go to the Edit menu at the top and choose Clear Values. This removes only the data. If you want to remove the data and any formatting you applied (like bold text, background color, or number format), choose Clear All instead.

You can also right-click on the cell and choose Clear Values from the menu that appears. This is faster if you are clearing just one or two cells.

Delete a cell and shift the surrounding cells

Delete a cell when you want Sheets to move the cells around it to fill the space. This is useful when you have a row or column you no longer need and you want to remove it entirely, not just empty it.

Right-click on the cell or range you want to delete. Choose Delete Cells. A small menu will appear asking whether you want to shift cells left or shift cells up. If you are deleting a cell in the middle of a row, choose Shift Left — the cells to the right will move left to fill the gap. If you are deleting a cell in the middle of a column, choose Shift Up — the cells below will move up.

Be careful with this option if your spreadsheet has formulas. When cells shift, any formula that referenced the deleted cell will show a #REF! error, because the cell it was pointing to no longer exists.

Delete an entire row or column at once

If you want to remove a whole row or column, right-click on the row number on the left side or the column letter at the top. Choose Delete Row or Delete Column. Sheets will remove the entire row or column and shift everything else to fill the gap.

This is cleaner than deleting individual cells one at a time, because you do not have to choose shift direction — Sheets knows to shift up for rows and left for columns. But again, any formulas that referenced cells in that row or column will break.

Undo a deletion if you made a mistake

If you delete a cell or row and realize you made a mistake, press Ctrl+Z on Windows or Cmd+Z on Mac when ready. This will undo the deletion and put everything back where it was. You can undo multiple steps in a row if you need to go back further.

Sheets keeps your undo history for a while, but not forever. If you close the spreadsheet and come back later, you will not be able to undo old deletions. So if you delete something important, undo it right away.

When to clear versus when to delete

Use Clear Values when you want to empty a cell but keep the spreadsheet structure the same. This is the right choice if you have formulas elsewhere that reference this cell, or if you want to reuse the cell later.

Use Delete Cells when you are removing data that you will not need again and you want to tighten up your spreadsheet. This is common when you are cleaning up a list and removing entries that no longer explore.

If you are not sure which one you need, clear the cell first. You can always delete it later if you decide you want to remove the empty cell entirely.

Frequently Asked Questions

What is the #REF! error and why does it appear?

A #REF! error means a formula is trying to reference a cell that no longer exists. This usually happens when you delete a cell that another formula was pointing to. To fix it, either undo the deletion or edit the broken formula to point to a different cell.

Can I delete multiple cells at once?

Yes. Select all the cells you want to delete by clicking the first one, holding Shift, and clicking the last one. Then right-click and choose Delete Cells. You will still need to choose whether to shift left or shift up.

If I clear a cell, does the formatting stay?

If you use Clear Values, the formatting stays — the cell will still be bold, colored, or formatted as currency if you set it that way. If you use Clear All, both the data and the formatting are removed.

What happens to my formulas if I delete a cell they reference?

The formula will show a #REF! error because it cannot find the cell it was looking for. You will need to edit the formula to point to a different cell, or undo the deletion to restore the original cell.

Is there a keyboard shortcut to delete a cell?

There is no single keyboard shortcut to delete a cell in Sheets the way there is in Excel. You have to right-click and choose Delete Cells, or use the Edit menu. However, you can press Delete on your keyboard to clear the contents of a cell without deleting the cell itself.