How to Delete Cells in Excel: A Complete Guide

Deleting cells in Excel sounds straightforward, but there's an important distinction that catches many users off guard: deleting a cell is not the same as clearing a cell's contents. Understanding the difference — and knowing which method fits your situation — can save you from accidentally shifting your data in unexpected ways.

Deleting vs. Clearing: Why It Matters

When you clear a cell, you remove its contents (or formatting, or both), but the cell itself stays in place. The surrounding cells don't move.

When you delete a cell, you remove the cell entirely from the grid. Because Excel's spreadsheet structure must remain intact, it then asks you how to fill the gap — by shifting adjacent cells up or to the left.

This distinction matters most when your data is arranged in structured tables, where an unintended shift can misalign entire columns or rows.

How to Delete a Single Cell or a Range of Cells

Using the Right-Click Menu

Select the cell or range of cells you want to delete.
Right-click on the selection.
Choose "Delete…" from the context menu.
A dialog box appears asking how to shift the remaining cells:
- Shift cells left — fills the gap by moving cells from the right
- Shift cells up — fills the gap by moving cells from below
- Entire row — deletes the full row(s) containing the selection
- Entire column — deletes the full column(s) containing the selection
Select your preferred option and click OK.

Using the Ribbon

Select your cell or range.
Go to the Home tab on the ribbon.
In the Cells group, click the dropdown arrow next to "Delete."
Choose from:
- Delete Cells… (opens the shift dialog)
- Delete Sheet Rows
- Delete Sheet Columns
- Delete Sheet (removes the entire worksheet tab)

Using a Keyboard Shortcut 🖱️

Select your cells, then press Ctrl + Minus (–) on Windows.
On Mac, the shortcut is Ctrl + Hyphen (–) or Command + Minus (–) depending on your version.

This opens the same delete dialog described above.

Deleting Entire Rows or Columns

If you want to remove a full row or column — rather than just individual cells — the process is similar but skips the shift dialog entirely, since Excel knows exactly what to do.

Right-click a row number (on the left side of the sheet) and select "Delete" to remove the entire row.
Right-click a column letter (at the top of the sheet) and select "Delete" to remove the entire column.
You can select multiple rows or columns by holding Ctrl while clicking their headers, then deleting in one step.

Deleting Multiple Non-Contiguous Cells

To delete cells that aren't next to each other:

Hold Ctrl while clicking each cell or range you want to select.
Right-click and choose "Delete…"
Note: Excel will apply the same shift direction to all selected cells, which can sometimes produce unexpected results across different parts of the sheet. Review your data carefully after this operation.

What Happens to Formulas When You Delete Cells?

This is where things get more sensitive. If other cells contain formulas that reference the cells you're deleting:

If you delete cells that are directly referenced, those formulas will display a #REF! error.
If you shift cells, formula references may update automatically — or may point to unintended cells.

Before deleting, it's worth using Ctrl + ` (the grave accent key) to toggle formula view, so you can see which cells are being referenced across your sheet.

Clearing Cells Instead of Deleting Them

If your goal is simply to remove data without disturbing the layout, clearing is usually the safer choice:

Action	How To	What It Does
Clear contents	Press Delete key	Removes values, keeps formatting
Clear formatting	Home → Clear → Clear Formats	Removes formatting, keeps values
Clear all	Home → Clear → Clear All	Removes everything in the cell
Clear comments	Home → Clear → Clear Comments	Removes notes/comments only

The Delete key on your keyboard performs a clear, not a cell deletion — a common source of confusion for newer Excel users.

Variables That Affect Your Approach 🔍

The right deletion method depends on several factors specific to your spreadsheet:

Data structure — A flat list tolerates upward shifts well; a side-by-side comparison table may not tolerate leftward shifts at all.
Presence of formulas — Heavily formula-dependent sheets require more caution around any deletion.
Excel version — Behavior is consistent across modern Excel versions (2016, 2019, 2021, Microsoft 365), but Excel Online has a slightly simplified ribbon that may present options differently.
Table vs. range — If your data is formatted as an official Excel Table (Insert → Table), deleting rows behaves differently than in a standard range, as the table structure adjusts automatically.
Shared or protected workbooks — In collaborative or protected sheets, deletion options may be restricted by the sheet's permissions settings.

A Note on Undo ⚠️

If a deletion shifts your data unexpectedly, Ctrl + Z (Windows) or Command + Z (Mac) will undo the action immediately. Excel maintains a multi-step undo history, so you can step back through several operations if needed — though once a file is saved and closed, that history is gone.

How aggressively you can delete and restructure a sheet ultimately comes down to how your specific workbook is built, what's referencing what, and how much disruption the surrounding data can absorb.