Fix Excel Font Color Changes After Subscript or Superscript
Question details
Identify why text following subscript or superscript changes color when an XLSM workbook is opened directly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An XLSM workbook contains text with subscript or superscript formatting and is opened directly rather than from within Excel.
- Observed behavior
- Text following the subscript or superscript changes to the black font color defined by the Normal style when the workbook is opened directly. The change does not occur when the workbook is opened from within Excel.
Identify an affected cell and note the intended font color of the text following the subscript or superscript. Compare the same cell when opening the workbook directly and through Excel’s File > Open menu.
Open Excel First, Then Open the Workbook
Use this workaround when opening the XLSM file from within Excel preserves the expected font color.
Launch Microsoft Excel before opening the XLSM workbook.
In Excel, select File > Open, browse to the XLSM file, and select Open.
Go to an affected cell and verify that the text after the subscript or superscript retains its intended color.

Review the Normal Style and Character Formatting
Check whether the workbook’s Normal style or formatting on individual characters is related to the color change.
Compare the Workbook in Another Excel Version
Use a version comparison to help determine whether the behavior depends on how a particular Excel installation opens the file.
Review Spreadsheet Formatting with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move between office suites. It does not fix Excel’s direct-opening behavior; check any workbook features you rely on before migrating.

Frequently Asked Questions
Why does the font turn black after subscript or superscript?
The reported black color matches the workbook’s Normal style. The cause is not confirmed, so inspect the Normal style and the affected characters, then compare opening the file directly with opening it through Excel’s File > Open menu.
How can I avoid the color change when opening the workbook?
Start Excel first, then choose File > Open and browse to the XLSM workbook. In the reported case, this opening method preserves the expected color.
Where can I check the Normal style’s font color?
In Excel, go to Home > Cell Styles, right-click Normal, select Modify, and choose Format to inspect its font settings.
Will changing the Normal style affect other cells?
It can affect other cells that use the Normal style. Check the rest of the workbook after changing it through Home > Cell Styles > Normal > Modify.
Can WPS Office fix the Excel opening issue?
WPS Office provides an alternative for viewing and editing spreadsheets, but it does not change how Microsoft Excel opens a workbook. Check compatibility with the workbook’s macros and formatting before relying on another application.




