What happens when you delete a cell in Sheets

When you delete a cell in Google Sheets, the cells around it shift to fill the gap — they don't simply vanish and leave an empty space. If you delete a cell in the middle of a row, the cells to the right slide left. If you delete a cell in the middle of a column, the cells below slide up. This matters because formulas and references in other cells may break if they were pointing to the deleted cell, and your data structure changes.

You have three main choices: delete just the contents (keeping the cell itself), delete the entire row or column, or delete the cell and shift the surrounding cells. Which one you pick depends on whether you want to keep your grid structure intact or reorganize it.

Key Takeaways

  • Right-click a cell and choose "Delete values" to clear only the contents while keeping the cell in place.
  • Right-click and select "Delete cells" to remove the cell itself and shift surrounding cells left or up to fill the gap.
  • Deleting a cell that other formulas reference will break those formulas and show a #REF! error.
  • You can select multiple cells at once and delete them all together using the same methods.

Clearing cell contents without removing the cell

The safest option for most situations is to clear only what's inside the cell, leaving the cell itself in place. This keeps your spreadsheet structure unchanged and prevents formulas elsewhere from breaking.

Click the cell you want to clear. Right-click and select Delete values. The cell becomes empty, but it stays where it is — nothing shifts. If you want to clear multiple cells at once, click the first one, then hold Shift and click the last one to select a range. Right-click and choose Delete values again, and all selected cells clear at once.

You can also select cells by clicking and dragging across them, or by clicking one cell, holding Ctrl (or Cmd on Mac), and clicking others individually to select non-adjacent cells. Then right-click and delete values from all of them together.

Deleting a cell and shifting others to fill the gap

If you want to remove a cell entirely and have the surrounding cells move to close the space, right-click the cell and select Delete cells. A small menu appears asking which direction you want the remaining cells to shift: left or up.

Choose Shift cells left if you want cells to the right of the deleted cell to move left and fill the gap. Choose Shift cells up if you want cells below the deleted cell to move up. This is useful when you have a row or column you no longer need and want to compact your data, but be aware that any formulas referencing the deleted cell will break and show a #REF! error.

If you select multiple cells before right-clicking, you can delete them all at once. Sheets will shift the remaining cells in the direction you choose.

Removing entire rows or columns

When you need to delete a whole row or column rather than individual cells, right-click the row number on the left side or the column letter at the top. Select Delete row or Delete column. The entire row or column disappears, and all cells below or to the right shift up or left to fill the space.

This is cleaner than deleting individual cells one at a time if you're removing a lot of data at once. It's also the method to use when you have a row or column that's completely unnecessary to your spreadsheet.

What to do if you delete the wrong cell

If you delete something by mistake, press Ctrl+Z (or Cmd+Z on Mac) immediately to undo. Sheets keeps a history of your recent changes, so you can undo multiple steps if needed. Click the undo arrow at the top left of the spreadsheet, or use the keyboard shortcut, and your deleted content comes back.

If you've made many changes since the deletion and want to go back further, click the undo arrow and select from the list of recent actions. You can jump back to any point in your editing history.

Fixing broken formulas after deletion

When you delete a cell that another formula references, that formula displays #REF! as an error. This means the formula is looking for data that no longer exists. You'll need to edit the broken formula and point it to a different cell, or delete the formula if it's no longer useful.

Click the cell with the #REF! error. Look at the formula bar at the top to see what the formula is trying to do. Edit it to reference a cell that still exists, or clear the cell entirely if the formula is no longer needed. If many formulas are broken, consider using Ctrl+Z to undo the deletion and try a different approach — like clearing values instead of deleting cells.

Selecting and deleting multiple cells at once

You can select a range of cells and delete them all together. Click one cell, then hold Shift and click another cell to select everything between them. Or click and drag across the cells you want. Right-click and choose either Delete values or Delete cells depending on what you need.

To select cells that aren't next to each other, click the first cell, then hold Ctrl (or Cmd on Mac) and click each additional cell. When you right-click, the same delete options appear, and your action applies to all selected cells at once. This saves time when you're cleaning up data scattered across different parts of your spreadsheet.

Frequently Asked Questions

Can I delete a cell without shifting other cells?

Yes. Right-click and choose Delete values to clear only the contents. The cell stays in place and nothing shifts. If you want to remove the cell itself without shifting, that's not possible — deleting a cell always shifts surrounding cells to fill the gap.

What's the difference between Delete values and Delete cells?

Delete values clears what's inside the cell but leaves the cell itself in your spreadsheet. Delete cells removes the cell entirely and shifts surrounding cells to close the space. Use Delete values to keep your structure intact; use Delete cells when you want to reorganize your data.

Will deleting a cell break my formulas?

Only if another formula references the cell you're deleting. When that happens, the formula shows a #REF! error. If you delete a cell that no other formula uses, nothing breaks. Before deleting, you can search your sheet for formulas that reference that cell using Ctrl+H (Find and replace) to see what might be affected.

Can I undo a deletion?

Yes. Press Ctrl+Z (or Cmd+Z on Mac) immediately after deleting. You can undo multiple steps by clicking the undo arrow at the top left and selecting from your recent actions. Sheets keeps your editing history, so you can go back quite far if needed.

How do I delete a row or column instead of individual cells?

Right-click the row number on the left or the column letter at the top. Select Delete row or Delete column. The entire row or column disappears and surrounding rows or columns shift to fill the space. This is faster than deleting cells one at a time.