Formatting Issues

Fix Excel Deleting Cell Contents When Highlight Formatting Is Removed

Rana GarciaRana Garcia Nov 13, 2026 868 views

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.

Fix Excel Deleting Cell Contents When Highlight Formatting Is Removed
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Account page

Open Excel, click File, and select Account in the left menu.

2
Check for Office updates

In Product Information, click Update Options and choose Update Now. Let Microsoft Office download and install pending updates.

3
Restart Excel and retest

Close and reopen the workbook, select the highlighted table, remove the highlight formatting, and confirm the cell contents remain.

Update Microsoft Excel to the latest version
Expected result: After the update, removing highlight formatting should no longer clear cell values in most cases.
Free Microsoft Office alternative

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. 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. 2. Open your Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and choose the .xlsx workbook that loses cell contents in Excel.
  3. 3. Remove highlight formatting: Select the highlighted table or cells, click Home > Fill Color > No Fill, and verify that the cell contents remain intact.
Remove cell highlight formatting without clearing values in WPS SpreadsheetsFull compatibility with .xlsx, .xls, and other Microsoft Office formatsFree, lightweight Office suite with a familiar Excel-like ribbonSeamless migration from Microsoft Excel with formulas, tables, and formatting preserved
QA img-9

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.