The fastest way to clear a cell

To clear the contents of a single cell in Excel, click on the cell and press the Delete key. That's it — the cell empties, the formatting stays, and nothing else on your sheet changes.

If you want to clear multiple cells at once, click on the first cell, then hold Shift and click on the last cell in the range you want to clear. All the cells between them highlight. Then press Delete, and they all empty at the same time.

This method removes only what you typed — the numbers, text, or formulas inside the cell. The cell's background color, font style, borders, or any other formatting you applied stays exactly as it was.

Key Takeaways

  • Press Delete on a selected cell to remove only its contents while keeping the formatting intact.
  • Hold Shift and click to select a range of cells, then press Delete to clear them all at once.
  • Use Clear All from the Edit menu if you want to remove both contents and formatting from a cell or range.
  • Right-click on a cell to access the Clear Contents option, which works the same way as pressing Delete.
  • Undo any accidental clearing by pressing Ctrl+Z when ready after.

Clearing contents versus clearing formatting

Excel gives you two different ways to clear a cell, and which one you use depends on what you want to keep. When you press Delete, you remove only what's inside the cell — the data itself. The cell keeps its color, font size, bold or italic styling, borders, and any other visual formatting you've applied.

If you want to remove everything — both the data and the formatting — you need to use Clear All instead. Right-click on the cell and select "Clear Contents" to get the Delete behavior, or look for "Clear All" or "Clear Formats" in the same menu to remove the visual styling as well. The exact menu names vary slightly depending on your version of Excel, but the right-click menu always shows you the options available.

Selecting a range of cells to clear at once

When you have multiple cells to clear, selecting them all first saves time. Click on the first cell you want to clear. Then hold down the Shift key and click on the last cell in the range. Excel highlights every cell between the two clicks, and pressing Delete clears them all in one action.

You can also click and drag from the first cell to the last to select a range, then press Delete. If the cells you want to clear aren't next to each other, hold Ctrl (or Command on a Mac) and click on each individual cell you want to include. Then press Delete, and only those specific cells clear.

Using the menu instead of the Delete key

If you prefer using menus, you can clear a cell without touching the Delete key. Right-click on the cell or range you've selected, and a menu appears with several options. "Clear Contents" does the same thing as pressing Delete — it removes what's in the cell but leaves the formatting. "Clear All" removes both the contents and the formatting.

In older versions of Excel, you might see "Delete" in the menu, which opens a dialog asking whether you want to delete the cell itself (shifting other cells to fill the gap) or just clear its contents. If you only want to empty the cell without moving anything around, choose "Clear Contents" instead of "Delete."

What happens to formulas when you clear a cell

If a cell contains a formula — something like =SUM(A1:A10) — pressing Delete removes the entire formula. Any other cells that reference that formula will show an error like #REF! because the formula they depended on no longer exists.

Before you clear a cell with a formula, check whether any other cells on your sheet use that formula's result. You can do this by clicking on the cell and looking at the formula bar at the top to see what it contains. If you're not sure, press Ctrl+Z right after clearing to undo the action and get the formula back.

Undoing an accidental clear

If you clear a cell by mistake, press Ctrl+Z (or Command+Z on a Mac) when ready to undo the action. Excel remembers your last several actions, so you can press Ctrl+Z multiple times to step backward through what you've done. The moment you do something else — like type in a different cell — the undo history moves forward, so undo right away if you realize you made a mistake.

If you've already closed the file without saving, you cannot undo the clear. This is why it's worth saving your work regularly, especially if you're making big changes to a spreadsheet you depend on.

Clearing cells versus deleting rows or columns

Clearing a cell is different from deleting a row or column. When you clear a cell, it stays where it is — empty but still part of your sheet. When you delete a row or column, Excel removes it entirely and shifts everything else to fill the gap.

If you only want to empty out data without changing the structure of your sheet, always use Clear (Delete key or right-click menu). Use Delete Row or Delete Column only when you actually want to remove that row or column from the sheet and have everything shift over.

Frequently Asked Questions

Does pressing Delete remove the cell itself or just what's inside it?

Pressing Delete removes only what's inside the cell — the data, formula, or text. The cell itself stays in the same place on your sheet. If you want to remove the cell entirely and have other cells shift to fill the gap, you need to right-click and choose "Delete Cells" instead.

Can I clear a cell without removing its formatting?

Yes. Pressing Delete or right-clicking and choosing "Clear Contents" removes only the data inside the cell and leaves all formatting — colors, fonts, borders, and styles — exactly as they were. Use "Clear All" only if you want to remove the formatting too.

What if I clear a cell that other cells depend on?

Any cell with a formula that references the cleared cell will show #REF! error. Before clearing a cell, check whether other formulas use it. You can press Ctrl+Z right after clearing to undo and get the data back.

How do I clear a large range of cells quickly?

Click on the first cell, hold Shift, and click on the last cell in the range you want to clear. All cells between them highlight. Then press Delete, and they all empty at once. You can also click and drag to select a range, then press Delete.

Is there a way to clear cells without using the Delete key?

Yes. Right-click on the cell or range and select "Clear Contents" from the menu. This works exactly the same as pressing Delete. In some versions of Excel, you can also use the Edit menu at the top and look for a Clear option there.