Formatting Issues

Fix Excel Font Color Changes After Subscript or Superscript

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

Identify why text following subscript or superscript changes color when an XLSM workbook is opened directly.

Fix Excel Font Color Changes After Subscript or Superscript
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.
Before you start

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.

Solution 1Recommended

Open Excel First, Then Open the Workbook

Use this workaround when opening the XLSM file from within Excel preserves the expected font color.

1
Start Excel

Launch Microsoft Excel before opening the XLSM workbook.

2
Open the workbook

In Excel, select File > Open, browse to the XLSM file, and select Open.

3
Check the affected text

Go to an affected cell and verify that the text after the subscript or superscript retains its intended color.

Open Excel First, Then Open the Workbook
Workaround, not a confirmed fix: Opening Excel first avoids the reported behavior, but it does not establish why direct opening changes the formatting.
Free Microsoft Office alternative

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.

Inspect and edit spreadsheet font colors and character formattingCompatible with Microsoft Excel XLSX filesFamiliar interface for spreadsheet editingFree, lightweight office suite
QA img-9

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.