To delete cells highlighted with a particular fill color in Excel for Microsoft 365 on Windows, use Home > Find & Select > Find, search for that fill color, select the matching results, and press Delete to clear their contents. If you need to remove the cell positions themselves, use Home > Delete > Delete Cells instead—but first decide how the surrounding data should shift. These actions are different: clearing contents leaves cells and formatting in place, while deleting cells changes the worksheet layout.
What You’ll Need
- An editable Excel workbook, preferably with a saved backup if the highlighted cells contain important data.
- A clear idea of what you mean by delete: remove cell contents, remove cell positions, delete whole rows, or remove the highlight color only.
- If you are searching by color, a sample cell with the exact fill color you want to find. Similar-looking theme colors or shades can be different colors to Excel.
Step-by-Step
- Save a copy before making a large change. Choose File > Save As and save a separate copy, or save the workbook normally if you are comfortable reverting changes. Deleting contents can often be undone with Ctrl+Z, but a backup is safer when many cells or rows are involved.
- Decide what should happen to the cells. If you only want to remove text, numbers, or formulas from highlighted cells, you will clear their contents. If you want to remove the fill but keep the data, use the formatting steps in Tips instead. If the cells must be removed and neighboring cells shifted, plan whether Excel should shift cells up or left. For a table where records belong together, deleting entire rows is usually safer than shifting isolated cells.
- Open Find and Replace. Select Home > Find & Select > Find. In the Find and Replace window, select Options if the additional search settings are not already visible. Keep Within set to Sheet if you only want to search the current worksheet. Choose Workbook only if you intend to search every worksheet.
- Set the fill color to search for. Beside Format, open the dropdown and choose Format. In the Find Format window, select the Fill tab and choose the color used to highlight the cells. Check the preview before continuing. If you have a sample cell, you can instead use the Format dropdown and choose Choose Format From Cell, then select the sample. Choosing the Fill tab directly helps avoid matching other formatting, such as a font or border, by accident.
- Search the worksheet. Leave the Find what box empty if you want to find cells based on formatting rather than a particular text value, then select Find All. The results list shows the matching cells. If no results appear, confirm that you selected the right worksheet scope and exact fill color. See Troubleshooting if the color is produced by conditional formatting.
- Select all matching results. Click a result in the list, then press Ctrl+A while the Find and Replace window is active to select all listed matches. Check that the displayed result count and selected cells make sense. If you only want some matches, select individual entries instead, using Ctrl-click to add or remove individual results where supported.
- Close the search window without clicking the sheet. Select Close. Excel should keep the matching cells selected on the worksheet, often as a non-adjacent selection. Do not click an unrelated cell afterward, because that would replace the selection.
- Choose how to remove the matches. To clear only the contents, press Delete. The cells remain in place, and their fill color and other formatting remain. To remove contents and formatting but keep the cell positions, choose Home > Clear > Clear All. To delete cell positions, choose Home > Delete > Delete Cells and select Shift cells up or Shift cells left, then confirm. Review the result immediately; a shift can move neighboring data into different positions.
- Check the worksheet and save. Confirm that the intended cells changed and that formulas, records, and totals still line up. Press Ctrl+Z immediately if the selection or deletion was wrong. When the result is correct, save the workbook.
Important: The Find method is most reliable for cells with a regular, manually applied fill. If you want to delete whole records rather than individual cells, use the row-based method below instead of shifting separate cells around.
Delete whole rows when highlighted cells identify records
When each highlighted cell belongs to a record in a table, deleting its entire row keeps the remaining records together. If the range has headers, select a cell in it and choose Data > Filter. Open the filter dropdown for the column containing the highlighted cells, choose Filter by Color, and select the target fill color. Verify that the visible records are the ones you intend to remove. Select their row numbers, right-click, and choose Delete Row. Clear the filter afterward to inspect the remaining records. Filtering and deleting rows affects every value in each selected row, not just the colored cell, so do not use this approach when other data in those rows must be kept.
Common Mistakes
- Confusing clearing with deleting. The Delete key clears contents; it does not remove the cell or close the gap. Home > Clear > Clear All removes formatting as well as contents but still leaves the cell position. Home > Delete > Delete Cells changes the layout.
- Searching for the wrong version of a color. A theme color, tint, or manually chosen shade can look almost identical to the target but not match it. Select the color from the Fill tab carefully, or choose it from a representative sample cell.
- Deleting a cell when you meant to delete a record. Removing one cell and shifting other cells can misalign names, dates, or amounts in neighboring columns. If a highlighted cell marks a complete record, filter the table and delete its entire row only after checking what else is in that row.
- Assuming the highlight is a permanent fill. A color that appears when a value meets a rule may come from conditional formatting. A normal Find by format search might not identify those cells as expected. Find the rule or filter by the displayed color rather than treating the color as a manually applied fill.
- Using Clear All by mistake. Clear All removes data and formatting, including the highlight, but does not delete the cell position. Use it only when you really want the formatting gone too.
- Searching the whole workbook unintentionally. A Workbook search can select matches on other sheets. Set Within to Sheet for a single worksheet and check the results before deleting.
Tips
- Use a sample cell for precise matching. If you are unsure of the exact shade, choose Format From Cell and click a representative highlighted cell. For greater control, open the Format dialog and set only the Fill attribute rather than copying the sample’s font, border, and other formatting.
- Clear the search format afterward. A format criterion can remain in the Find window and affect later searches. Open Find again and use the Format dropdown’s Clear Find Format option before searching for ordinary text or another format.
- Use a filter for large, structured lists. Filtering by color lets you inspect the records before deleting them. Keep a header row and avoid selecting unrelated rows outside the table. If you remove filtered rows, confirm that hidden rows are not included in the selection.
- Remove color without removing data. Select the relevant cells and choose Home > Fill Color dropdown > No Fill. This keeps text, numbers, and formulas. For conditional formatting, change or remove the rule through Home > Conditional Formatting > Manage Rules instead; applying No Fill may not remove a color that a rule supplies.
- Keep a formula and data check in view. After deleting values, check nearby formulas and totals. A formula may now refer to a blank cell or return a different result. Undo if the change affects calculations you meant to preserve.
- Know the keyboard difference on Mac. On Windows, Delete clears selected contents and Ctrl+Z undoes. On Mac, Delete or Backspace may clear selected contents depending on the keyboard; Command+Z undoes. Ribbon labels and Find options can vary slightly by Excel for Mac release. Excel for the web has fewer format-search options; open the workbook in the desktop app for the Find-by-format steps above.
Troubleshooting
Find All returns no matches. Reopen Options and confirm that the search is set to the correct sheet or workbook. Check that the Find what box is empty if you are searching for any cell with the selected format. Reopen Format and choose the exact fill color again. If the color comes from a conditional formatting rule, use Manage Rules to identify the rule or try Filter by Color in a suitable table.
Excel selects too many cells. The search may be matching more formatting than intended, or the same color may be used elsewhere. Set the search format using only the Fill tab, restrict Within to Sheet, and inspect the Find All list before deleting. You can select only the specific results you want rather than selecting every match.
Pressing Delete did not remove the colored cells. Delete clears values, not fill formatting. If the cells now look highlighted but are empty, that is expected. To remove the color while preserving the cell positions, select the cells and choose Home > Fill Color dropdown > No Fill. To remove their positions, use Delete Cells and choose a shift direction only when moving nearby cells is safe.
The highlighted cells are part of a conditional formatting rule. Select a cell showing the color, then choose Home > Conditional Formatting > Manage Rules. Set Show formatting rules for to Current Selection or This Worksheet to locate the applicable rule. The rule explains which values or formula produce the highlight. If you want to delete the data that meets that condition, filter or select using the underlying criteria, verify the cells, and then clear their contents. Removing a conditional formatting rule changes the appearance; it does not delete cell data.
Delete Cells is unavailable or gives an error. A non-adjacent selection can prevent Excel from shifting several separate areas safely. Clear the contents of the selected matches instead, or handle one contiguous area at a time. If the range is an Excel table, deleting individual cells may also be restricted to protect its structure; delete a complete table row if the entire record should go.
Undo does not restore the intended result. Press Ctrl+Z on Windows or Command+Z on Mac promptly, before making other changes. If the workbook has been closed or the undo history is no longer available, restore the saved backup or use version history if the file is stored in OneDrive or SharePoint.
Frequently Asked Questions
Does pressing Delete remove the highlighted cell in Excel?
It clears the selected cell’s contents, such as text, numbers, or formulas. It does not remove the cell position or its fill color. Use Delete Cells if you need surrounding cells to shift.
Can I delete every cell with a particular fill color at once?
Yes. In desktop Excel, search by fill format, select the matching results, and press Delete to clear their contents. Check the results first, especially if the same color is used for different purposes.
Can I remove the highlight but keep the cell values?
Yes. Select the cells and choose Home > Fill Color dropdown > No Fill. If a conditional formatting rule supplies the color, edit or remove that rule instead.
Will deleting highlighted cells shift the cells around them?
Pressing Delete will not shift cells. Home > Delete > Delete Cells asks whether to shift cells up or left. Deleting entire rows removes those rows, so decide which behavior fits your data before confirming.
Why can Excel see a color but not find it by format?
The displayed color may come from conditional formatting, or the chosen search color may not be an exact match. Check the rule in Manage Rules, compare the exact fill shade, and try Filter by Color for a table.
Can I do this in Excel for the web?
Excel for the web can filter some ranges by color, but its format-search controls may not match the desktop app. For precise Find All searches by fill format, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Related
- How to Copy an Image in Excel: Clear Steps and Tips
- Copy Horizontal to Vertical in Excel: Transpose Data
- How to Copy an Entire Row 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
- How to Make a Bullet List in Two Columns in Microsoft WordTo make a bulleted list flow through two columns in Word, create or select the list, then choose…
- Excel Day Care in Clementi: Location and Enrolment GuideIf you are looking for Excel Day Care in Clementi, confirm the centre’s current address and operating status…
- Excel Consolidate Multiple Sheets Into One: 4 MethodsYes. In Excel for Microsoft 365 on Windows, you can combine sheets by appending their rows with Power…
- Automate Text to Columns in Excel: Methods and LimitsYes—but Excel’s Text to Columns command does not automatically repeat itself whenever new data arrives. For a one-time…
- How to Add Audio to a PowerPoint SlideshowTo add audio in PowerPoint for Microsoft 365 on Windows, open the slide where you want the sound,…
- How to Create an Email Template in Outlook DesktopIn classic Outlook for Windows, create a message, choose File > Save As, and save it as an…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.