Fix Excel Deleting Cell Contents When Highlight Formatting Is Removed
Question details
The user needs to remove highlight formatting from an Excel table without losing the cell contents and wants to understand why clearing the highlight deletes data.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- The user is removing highlight formatting from a table in an Excel workbook and the cell values disappear.
- Observed behavior
- Cell contents are deleted or appear deleted when highlight formatting is removed.
Make a copy of the affected workbook and test only on the copy. Check whether the behavior occurs in one workbook or all workbooks, because this determines whether you need an application repair or a workbook rebuild.
Update Microsoft Excel to the latest version
Use this first to rule out an Excel bug that has already been fixed by a Microsoft Office update.
If the data loss is caused by an Excel defect, installing the latest Office update often stops highlight removal from clearing cell values.
Open Excel, click File, and select Account in the left menu.
In Product Information, click Update Options and choose Update Now. Let Microsoft Office download and install pending updates.
Close and reopen the workbook, select the highlighted table, remove the highlight formatting, and confirm the cell contents remain.

Start Excel in Safe Mode to disable add-ins
Use this when an add-in or startup program may be triggering the deletion while highlight formatting is removed.
Repair Microsoft Office using Online Repair
Use this if updating and Safe Mode do not stop Excel from deleting cell contents when highlight formatting is removed.
Use WPS Office Spreadsheets to remove highlight formatting without losing cell contents
If Microsoft Excel continues deleting cell contents when highlight formatting is removed, WPS Office Spreadsheets is a free, lightweight alternative that opens .xlsx files with a familiar ribbon interface. You can clear highlight formatting safely and continue working with existing Excel workbooks.
- 1. Download WPS Office: Go to the WPS Office download page and click Download WPS Office Free to install WPS Office on your Windows PC.
- 2. Open your Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and choose the .xlsx workbook that loses cell contents in Excel.
- 3. Remove highlight formatting: Select the highlighted table or cells, click Home > Fill Color > No Fill, and verify that the cell contents remain intact.

Frequently Asked Questions
Why does Excel delete cell contents when I remove highlight formatting?
This may be an Excel bug, an add-in conflict, or workbook-specific corruption. Update Office first, then test in Excel Safe Mode and use Online Repair if needed.
Can I recover cells deleted after removing highlight formatting in Excel?
If you have not saved the workbook, press Ctrl+Z immediately to undo the action. If the file was saved, check the version history or restore a backup copy.
How do I start Excel in Safe Mode?
Close Excel, press Windows+R, type excel /safe, and select OK. Safe Mode opens Excel without most add-ins and startup programs.
What should I do if the problem occurs only in one workbook?
The workbook may be corrupted or contain problematic formatting. Copy the data to a new workbook, then test highlight removal after updating or repairing Office.
Does WPS Office have the same highlight formatting deletion problem?
No. WPS Spreadsheets can open .xlsx files and remove highlight formatting while preserving cell values, making it a practical free alternative to Microsoft Excel.




