To delete the contents of every cell with a particular fill color in Excel for Microsoft 365 on Windows, use Home > Find & Select > Find, set a fill-format criterion, choose Find All, select all results, then clear their contents. This keeps the cells and their highlighting in place. If the color comes from conditional formatting, or you want to remove the color rather than the contents, use the alternatives below.
What You’ll Need
- A copy of the workbook, especially if the highlighted cells contain important data. Clearing cell contents can remove values and formulas, and it may not be reversible after you close the workbook.
- Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac has similar Find and Clear features, though some dialog labels and keyboard shortcuts differ. If you use Excel for the web and cannot find a format-search option, open the workbook in the desktop app.
- A clear idea of what highlighted means in your sheet: a manually applied cell fill, a color displayed by a conditional-formatting rule, or selected text/cells. These cases need different approaches.
Step-by-Step
- Save a working copy and decide what to remove. If you want to erase values and formulas while keeping the cells and their fill color, use Clear Contents in step 6. If you want to remove the fill color but keep the values, do not clear contents; use Home > Clear > Clear Formats instead. If you mean delete entire worksheet rows, that is a separate operation and is not the default method here.
- Open Find and expose its options. On Windows, press Ctrl+F or select Home > Find & Select > Find. In the Find and Replace dialog, select Options if the search settings are hidden. Set Within to Sheet if you only want matches on the current worksheet. Choose Workbook only if you deliberately want to search across sheets; check the results carefully before clearing anything. On Mac, press Command+F or use the Find command on the ribbon or Edit menu, then show the search options if needed.
- Set a fill-only format to find. In the expanded Find dialog, open the Format menu and choose Format. In the Find Format dialog, go to the Fill tab and choose the fill color you want to match. Set only the fill criterion; do not add font, border, number-format, or protection criteria unless you specifically need them. If you already searched by a format earlier, clear the old find-format settings first, then set the new fill. This prevents a leftover criterion from excluding cells you expect to find.
- Use a sample cell only when its formatting is a reliable match. If available in your dialog, use Format > Choose Format From Cell and select one example cell. This can be quicker than choosing a color manually. However, it may match more than the fill: the sample can include other formatting details such as borders or number format. If the results seem incomplete, replace the sample with a fill-only criterion using the Fill tab.
- Find all matching cells and select the results. Select Find All. Excel displays the matching cells in a results list. Click in that list and press Ctrl+A on Windows to select all the found cells. On a Mac, use Command+A when the results list has focus. The matching cells should now be selected on the sheet, often as a multi-area selection. Before clearing, check the list and the selection: if it includes cells outside the intended range or on other sheets, cancel and narrow the search.
- Clear the contents without deleting the cells. With the matches selected, choose Home > Clear > Clear Contents. This removes entries and formulas from the selected cells but leaves their fill and other formatting in place. You can also press the Delete key on Windows; on a Mac, use the Delete key, which may be labeled Backspace on some keyboards. The ribbon command is the safer choice if your keyboard’s Delete key behaves differently.
- Check the result and save. Look over several formerly highlighted cells, including any at the top and bottom of the range. Confirm that their contents are gone and the formatting remains as intended. If you cleared the wrong cells, use Ctrl+Z on Windows or Command+Z on Mac immediately, before doing other work. When the result is correct, save the workbook.
For a conditional-formatting color: the fill you see may be produced by a rule rather than stored as a normal cell fill. Find by format may not identify cells based on the color currently displayed by that rule. If the range has filter arrows, open the relevant column’s filter menu and choose Filter by Color, then select the displayed color. Select the visible matching cells in the data area, use Home > Find & Select > Go To Special > Visible cells only if necessary, and choose Home > Clear > Clear Contents. Check carefully that the selection excludes the header and hidden rows. If the data is not filterable or the rule is complex, inspect Home > Conditional Formatting > Manage Rules to understand which cells the rule affects before deciding what to clear.
Common Mistakes
- Using Clear All when you only meant to erase data. Home > Clear > Clear All removes contents and formatting, so the highlight and other cell formatting disappear too. Choose Clear Contents when formatting should stay.
- Pressing Delete when you meant to remove the color. Delete clears cell contents; it does not remove the fill. To keep values and remove ordinary cell formatting, select the cells and choose Home > Clear > Clear Formats. That can also remove number formats, borders, and other formatting, not just the fill.
- Assuming a color on screen is a manual fill. Conditional formatting can display a color without applying that fill directly to the cell. Searching for a regular fill may return no matches or the wrong set. Identify the rule or filter by the displayed color instead.
- Searching the entire workbook by accident. A workbook-wide search can include similarly formatted cells on other worksheets. Set Within to Sheet unless you truly want results from multiple sheets, and review the result list before clearing.
- Clearing whole rows when only some cells matched. A multi-cell selection can contain matches in separate columns. Deleting rows removes neighboring data as well. Use Clear Contents for selected matching cells unless removing entire records is your deliberate goal.
Tips
- Use a distinctive format for future cleanup. If you often mark temporary data for deletion, give it a consistent fill color that is not also used for warnings, headings, or important status indicators. A unique color makes the search results easier to verify.
- Limit the search to a known area. If only one table or block is relevant, select that range before opening Find and use the sheet-level search settings carefully. When in doubt, use Find All and inspect the addresses rather than assuming Excel will infer your intended block.
- Keep a record before bulk clearing. Copy the target range to a spare worksheet or save a separate workbook copy. This is useful when the matches include formulas, because clearing a formula removes the calculation as well as its displayed result.
- Use the right clear command for the goal. Clear Contents removes values and formulas but retains formatting. Clear Formats removes formatting but retains values and formulas. Clear All removes both, so reserve it for cells you truly want reset.
- Check for merged cells and protected sheets. Merged areas can make selection and clearing less predictable, while sheet protection can block edits. If a command is unavailable, review the layout and the Review tab’s protection settings before repeating the operation.
Troubleshooting
Find All returns no matches: confirm the target cells use a direct fill, that you selected the correct color, and that Find Format has no leftover criteria. Try selecting Format > Clear Find Format in the Find dialog, then set only the Fill criterion again. Also confirm that Within is set to the correct scope. If the color is conditional, use the conditional-formatting approach rather than relying on an ordinary fill search.
Some cells are missing from the results: the cells may look alike but use different theme colors, tints, or formatting. Select a sample from each visual group and compare the results. If you used Choose Format From Cell, try choosing the fill explicitly in the Fill tab so unrelated formatting does not affect the match. A conditional-formatting rule may also apply to only part of the range.
Too many cells are selected: check whether the search includes the whole workbook, or whether the same fill color is used elsewhere on the sheet. Undo immediately if you already cleared contents, then repeat with a narrower scope or a more specific format. Avoid clearing until the result list and selected cells match the intended targets.
The color remains after clearing: that is expected when you chose Clear Contents; this command preserves formatting. If you want the color gone too, select the cells and use Clear Formats, understanding that other formatting may be removed. If the color is conditional, changing or removing the relevant rule through Home > Conditional Formatting > Manage Rules may be necessary.
Excel will not let you clear the cells: check whether the worksheet is protected, whether the workbook is read-only, or whether the selection includes merged or otherwise restricted cells. If protection is intentional, ask the workbook owner for permission rather than trying to bypass it. After resolving the restriction, repeat the selection and clear operation.
Frequently Asked Questions
Does pressing Delete remove the highlight in Excel?
Usually no. Delete removes the selected cells’ contents, while their fill formatting remains. Use Clear Formats to remove ordinary formatting, or adjust the conditional-formatting rule if that rule supplies the color.
Can I delete only the cells highlighted in one color?
Yes. Use Find All with a fill-only format criterion, select all results, and clear their contents. Check the search scope and result addresses first, especially if that color is used in multiple parts of the sheet.
Will this delete formulas as well as typed values?
Yes. Clear Contents removes both constants, such as typed numbers and text, and formulas in the selected cells. Make a copy first if you may need those formulas later.
How do I remove highlighting but keep the cell contents?
Select the affected cells and choose Home > Clear > Clear Formats for a normal fill. This may also remove number formats, borders, and other styling. For conditional formatting, edit or remove the applicable rule instead.
Can I do this in Excel for the web?
Some selection and formatting tools differ in the browser, and the desktop Find dialog’s format-search controls may not be available. If you cannot search by fill or reliably select the matches, open the workbook in Excel for Microsoft 365 on Windows or Mac and follow the desktop steps.
Does clearing the contents remove entire rows?
No. Clear Contents empties selected cells but leaves the rows, columns, and worksheet structure in place. Delete worksheet rows only if you intentionally want to remove every cell in those records and shift the remaining data.
Related
- Copy Only Filtered Data in Excel: Step-by-Step
- How to Copy Into Multiple Cells in Excel Without Errors
- How to Copy in Reverse Order in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Copy an Entire Excel Spreadsheet to a New FileTo copy an entire Excel spreadsheet into a separate file, open the workbook in Excel for Microsoft 365…
- Excel Formatting Keyboard Shortcuts: A Practical GuideIn Excel for Microsoft 365 on Windows, Ctrl+1 opens Format Cells, while Ctrl+B, Ctrl+I, and Ctrl+U apply bold,…
- Excel Flash Fill for an Entire ColumnYes. In Excel for Microsoft 365 on Windows, enter one example in the first cell of an empty…
- Freeze Panes in Excel: Keep Rows and Columns VisibleTo keep headings or labels visible while you scroll in Excel, use View > Freeze Panes. Choose Freeze…
- Power Query Keep Duplicates: How the Command WorksYes. Power Query’s Keep Duplicates command keeps every row whose value—or combination of values—in the selected columns occurs…
- How to Create and Share a Calendar in Microsoft OutlookTo create a calendar you can share, add a separate calendar in Outlook, then use its sharing settings…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.