Excel Not Deleting All Selected Cells? How to Fix It

Errors & fixes · Updated November 18, 2026

If Excel is not deleting all the selected cells, first check whether you pressed Delete to clear their contents or used Home > Delete to remove cells; those are different actions. If Delete leaves some cells unchanged, check for a protected sheet, filtered or hidden rows, merged cells, or a formula that controls the cells you are trying to change.

Clear contents or remove cells?

Excel uses “delete” to describe two operations that can look similar but have different results. Pressing the Delete key on Windows clears the contents of the selected cells. It removes typed values and formulas, but ordinarily leaves the cells in place with their formatting, borders, and position intact. For example, if B2:B5 contains numbers with a yellow fill, selecting that range and pressing Delete removes the numbers but keeps the yellow fill.

To remove cells from the grid and move neighboring cells into the gaps, use the ribbon command Home > Delete > Delete Cells. Excel then asks whether to shift cells up or left. To remove entire rows or columns, choose Home > Delete > Delete Sheet Rows or Delete Sheet Columns instead. Removing cells or rows can change references and the layout of nearby data, so confirm the selection before choosing that command.

  • Clear values or formulas: Select the cells and press Delete, or choose Home > Clear > Clear Contents.
  • Clear everything, including formatting: Choose Home > Clear > Clear All.
  • Remove cells and close the gap: Choose Home > Delete > Delete Cells, then specify the direction to shift.

On a Mac, the keyboard’s Delete key generally acts like Backspace on a Windows keyboard and clears the selected cells’ contents. Ribbon commands are a dependable alternative if your keyboard has different Delete or Fn keys. In Excel for the web, the Delete key also clears contents; use the Home ribbon’s Clear options when you need to distinguish clearing from removing cells.

Check whether the whole range is actually selected

A selection can be less obvious than it looks. Excel shows the active cell—the cell where typing would begin—with a distinct outline or appearance inside a larger highlighted range. If only one cell is selected, Delete will clear only that cell. Click and drag across the intended range, or click its first cell and Shift-click its last cell, then check the highlighted outline before clearing.

For a large, continuous range, use the Name Box to the left of the formula bar. Type a reference such as B2:D20 and press Enter; Excel selects that range. You can then press Delete to clear its contents. Be careful with a range reference: if the selection includes a title, notes, or formulas that should remain, those cells will be cleared too.

Nonadjacent selections are also possible. Hold Ctrl on Windows while selecting separate cells or ranges, then press Delete to clear the selected areas. On Mac, use Command while selecting nonadjacent areas. If one part seems to remain, click each area and verify that it was added to the selection; clicking elsewhere without the modifier key replaces the existing selection.

Filtered lists and hidden rows

Filters and hidden rows are a frequent cause of surprises. A filtered table may show only matching records, while rows that do not match remain in the worksheet but are hidden from view. A range selected by dragging or by entering a reference can include those hidden rows. If you clear that range, you may remove data that was not visible, even though the visible rows look like the only ones selected.

When you intend to clear only visible cells, select the range and use Home > Find & Select > Go To Special > Visible cells only, then choose OK and press Delete. In desktop Excel for Windows, Alt+; is the shortcut for selecting visible cells only after selecting the range. If the shortcut does not work on your keyboard or Excel version, use the ribbon path. Excel for Mac may not offer the same shortcut; Go To Special is the safer route. Availability and exact selection behavior can differ in Excel for the web, so check the selected range carefully there.

This distinction matters when editing a filtered customer list, for example. If a filter shows customers in one region and you clear a column of notes, selecting visible cells only helps avoid clearing notes in rows hidden by the filter. If you actually intend to clear every record, including filtered-out rows, do not restrict the selection to visible cells.

Protected sheets and locked cells

A protected worksheet can prevent edits to locked cells. Excel may display a message that the cell or chart is protected, or a command may appear unavailable. Protection can also explain why some cells in a selection clear while others do not: the editable cells are unlocked, but the remaining cells are locked.

Check the Review tab for Unprotect Sheet. If the sheet is protected, select that command; Excel may require the password set by the workbook’s owner. Once unprotected, try clearing the intended cells again. If you do not know the password, contact the person who manages the workbook rather than trying to bypass protection. Workbook structure protection is a separate setting and usually concerns adding, deleting, or moving sheets, not editing cell contents.

Protection is not the same as a cell being locked. Cells are commonly marked as locked by default, but that setting only restricts edits after sheet protection is turned on. If the sheet is not protected, the Locked setting by itself does not normally stop you from clearing a cell.

Merged cells and irregular selections

Merged cells combine two or more neighboring cells into one displayed area. The value is stored in the upper-left cell of the merged range, and Excel may require you to select the complete merged area before changing it. A selection that crosses merged and unmerged cells can also behave differently from a simple rectangular range, or produce a warning when you try to shift or delete cells.

If a merged area is involved, click it and inspect Home > Merge & Center to see whether merging is enabled. To clear its displayed value, select the merged area and press Delete. If Excel rejects the selection or you need to edit the surrounding grid, consider using Merge & Center to unmerge it first, then select and clear the individual cells you intend to change. Unmerging can affect the layout, so check the contents and appearance afterward.

Irregular ranges can also include cells that are not obvious at a glance, such as a large selection containing blank cells or a whole column selected by clicking its letter. Use the Name Box or the status bar to confirm the scope. A whole-column selection can contain more than a million rows in modern Excel, so selecting a specific data range is usually safer when the goal is to clear a small list.

Formulas, array results, and table columns

Cells that display formula results are not always independently editable. A normal formula cell can usually be cleared like other cells, but a formula copied down a column may be part of a calculation that the workbook needs. If only one displayed result is cleared and it later returns, check whether the cell is in an Excel table’s calculated column or is being repopulated by a query, macro, or other workbook process.

Dynamic array formulas create a different restriction. One formula in an anchor cell can return results across a spill range; the other displayed results are outputs, not separate formulas that can be deleted one by one. To remove the results, clear the anchor formula. If you try to clear just part of the spill range, Excel may report that you cannot change part of an array. Older, legacy array formulas can likewise require selecting the entire array range before clearing it. Check the formula bar and the surrounding cells to identify which case applies before removing anything.

For a table column that automatically fills a formula, clearing a cell may not have the effect you expect if Excel restores the calculated-column formula. If your goal is to remove the formula from the entire column, select the relevant table cells and check the table’s formula and auto-fill behavior. If you only want to hide a result, changing the formula or the table’s design may be more appropriate than repeatedly clearing cells.

When the Delete command is unavailable or appears ineffective

If the Delete key does nothing, confirm that Excel—not a cell editor or another dialog—is active, and check whether the worksheet is protected. If the key clears text inside a cell rather than the entire selection, you may be editing the cell: press Esc to cancel editing, select the cells again, and then press Delete. You can also test Home > Clear > Clear Contents to determine whether the issue is with the keyboard or with the cells’ editability.

If contents disappear but formatting remains, that is normal for Delete and Clear Contents. Use Home > Clear > Clear All only if you also want to remove formatting and other cell contents such as comments or notes where supported. Clear All is broader than a simple content clear, so avoid it if you need to preserve cell appearance.

If the content returns after clearing, investigate how it is supplied. A linked or refreshed data range, a table formula, a macro, or a formula in a spill range can repopulate or control displayed values. Check whether the cell contains a formula in the formula bar, whether the data is part of a table or query, and whether refresh or automation runs after the edit. In a shared or managed workbook, ask its owner before changing the source or structure.

A safe way to troubleshoot

Before clearing a large or important range, save the workbook or make a copy. Then work through the checks in order, starting with the least disruptive explanation:

  1. Confirm that the correct cells are highlighted and that you are not editing a cell.
  2. Decide whether you want to clear contents, clear formatting too, or remove cells and shift the grid.
  3. Check for filters, hidden rows, merged cells, and formulas that spill into the area.
  4. Look on the Review tab for sheet protection if some cells cannot be edited.
  5. Clear a small test range first, then inspect nearby data and formatting before applying the change to the full range.

Afterward, use Undo immediately if the wrong cells were changed: Ctrl+Z on Windows or Command+Z on Mac. Undo is not a substitute for a backup, especially when a workbook has been saved, refreshed, or changed by other people or processes. If Excel’s undo history is no longer available, restore a previous version from the file’s storage or ask the workbook owner about recovery options.

Frequently Asked Questions

Why does pressing Delete remove text but leave the cells?
That is the normal behavior. Delete clears cell contents but does not remove the cells from the worksheet or shift neighboring cells. Use Home > Delete > Delete Cells if you need to remove cells and move others into the space.

How do I delete only visible cells in a filtered range?
Select the range, choose Home > Find & Select > Go To Special > Visible cells only, and confirm. Then press Delete to clear the visible cells’ contents. Check the range first so hidden rows are not affected accidentally.

Why can’t I clear one cell in an array or spill range?
That cell may be part of a formula result controlled by another cell. Clear the formula in the array’s anchor cell, or select the complete legacy array range when Excel requires it. Do not remove just one displayed result unless Excel allows that cell to be edited independently.

Why do cleared cells keep coming back?
A table formula, refreshed data source, macro, or spill formula may be restoring or generating the displayed content. Check the formula bar and whether the cells belong to a table or refreshed range; clearing the visible result may not change its source.

How do I clear cells without removing their formatting?
Select the cells and press Delete, or choose Home > Clear > Clear Contents. Avoid Clear All if you want to preserve fills, borders, and number formats.

Choosing the right fix

Most apparent failures come down to the difference between clearing contents and deleting cells, an incomplete selection, or a restriction on editing. For ordinary values, select the intended range and press Delete. For filtered data, explicitly select visible cells only; for protected cells, use Unprotect Sheet if you are authorized; and for spill results, clear the formula that generates them. Identifying which situation applies before acting helps prevent a second problem, such as shifting the wrong cells or erasing hidden records.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.