Excel Performance Problems

How to Stop Excel's Unused Formatting Warning

Khadija Khan Sep 25, 2026 869 views

Question details

The user wants to find a way to disable the recurring notification warning that a high percentage of a workbook contains unused formatting and metadata.

How to Stop Excel's Unused Formatting Warning From Appearing

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working on older or heavily formatted spreadsheets where Excel continuously triggers an optimization prompt.
Observed behavior: Excel repeatedly displays an optimization warning about unused formatting that cannot be permanently disabled via settings, even when running in Safe Mode.

Before you start

Before attempting to clear unused formatting or optimize your file, create a backup copy of your workbook to ensure you do not accidentally lose important cell styles or data structures.

Solution 1Recommended

Manually Clear Unused Formatting to Stop the Prompt

Since Microsoft does not provide a setting to turn off this specific warning, manually removing the excess formatting from empty cells will stop the notification from triggering.

Excel triggers this warning when it detects that thousands of blank cells contain formatting, which inflates the file size. By clearing these unused rows and columns, the workbook will fall below the threshold that triggers the prompt.

Select unused columns

Click the first empty column header to the right of your actual data, then press Ctrl + Shift + Right Arrow to select all remaining columns to the edge of the sheet.

Clear formatting from columns

Navigate to the Home tab on the ribbon, locate the Editing group, click the Clear dropdown, and select Clear All.

Select unused rows

Click the first empty row header below your actual data, then press Ctrl + Shift + Down Arrow to select all remaining rows to the bottom of the sheet.

Clear formatting from rows

Go back to the Home tab, click Clear in the Editing group, and choose Clear All. Save the workbook to apply the changes and stop the warning.

Manually Clear Unused Formatting to Stop the Prompt

Check all worksheets: You may need to repeat this clearing process for every worksheet within the workbook if the file contains multiple heavily formatted sheets.

Solution 2

Submit Feedback to Microsoft

If you prefer not to alter your workbook and simply want an option to disable the notification, submitting direct feedback is the best way to request this feature.

Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience

If un-disable-able optimization warnings and sluggish performance are disrupting your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing your spreadsheets smoothly without unnecessary interruptions.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open your spreadsheet: Launch WPS Spreadsheet and drag-and-drop your existing .xlsx file directly into the workspace.
3. Work without interruptions: Continue editing your data, charts, and formatting seamlessly without being bothered by redundant optimization prompts.

No intrusive, un-disable-able optimization warnings during daily spreadsheet tasks.Highly compatible with Microsoft Excel (.xlsx, .xls) files and complex formulas.Lightweight architecture ensures fast loading and smooth scrolling even with large datasets.Familiar user interface guarantees a zero-learning-curve transition for Excel users.

Frequently Asked Questions

Why does Excel show the unused formatting warning?

Excel displays this warning when it detects that a large number of empty cells contain formatting (such as background colors, borders, or custom number formats). This excess metadata inflates the file size and reduces calculation performance, prompting Excel to suggest an optimization.

Can I disable the optimization prompt in Excel's Trust Center?

No, Microsoft currently does not provide a toggle in the Trust Center or Advanced Options menu to permanently disable this specific formatting optimization warning.

Will removing unused formatting change my actual data?

No, clearing unused formatting only affects the appearance of empty cells outside of your active data range. However, you should be careful to only select blank rows and columns to avoid clearing styles from your main dataset.

Does opening Excel in Safe Mode stop this warning?

No, users report that the unused formatting notification continues to appear even when Excel is running in Safe Mode with all add-ins and custom settings disabled, as it is a built-in file checking mechanism.

Excel & Data Problems