Office Settings & Configuration

Fix Text Formatting Changes in the Excel Formula Bar

Steve KSteve K Nov 18, 2026 868 views

Question details

The user wants to understand and troubleshoot apparent text formatting changes when selecting text in the Excel formula bar.

Fix Text Formatting Changes in the Excel Formula Bar
Product
Microsoft 365 Excel
Device & OS
not provided
Scenario
Selecting text in the formula bar while working with an Excel workbook.
Observed behavior
The selected text appears to change formatting in the formula bar. Reinstalling Office did not resolve the behavior.
Before you start

Check whether the text looks different only while it is selected in the formula bar or also changes in the cell after selection is cleared. Note the workbook and cell where the behavior occurs so you can repeat the test.

Solution 1Recommended

Test a New Workbook and Excel Safe Mode

Use these tests to determine whether the behavior is workbook-specific or related to Excel's startup environment.

The formula bar does not necessarily display cell font styling the same way as the worksheet. A selection highlight can also change how text appears without changing the cell's formatting.

1
Test a blank workbook

In Excel, select File > New > Blank workbook. Enter text in a cell, select the cell, and then select part of its text in the formula bar.

2
Compare the cell

Click away from the formula bar and check the cell on the worksheet. See whether its formatting actually changed or whether only the selected text looked different.

3
Start Excel in Safe Mode

On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Open the workbook and repeat the formula bar test. This Safe Mode method is for Windows.

4
Compare the results

If the issue occurs only in the original workbook, inspect its cell formatting. If it disappears in Safe Mode, check add-ins and Excel settings.

Test a New Workbook and Excel Safe Mode
Free Microsoft Office alternative

Work with Excel Files in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to continue working with cells and formulas while making a seamless move between office suites. It does not fix Microsoft Excel's formula bar behavior.

Edit spreadsheet cells and formulas in WPS SpreadsheetCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does selecting text in the formula bar change the cell's formatting?

Not necessarily. Selection highlighting can change how text looks in the formula bar. Click away and inspect the cell on the worksheet to see whether its formatting actually changed.

How do I open Excel in Safe Mode?

On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Then open the workbook and repeat the test.

How can I tell whether an Excel add-in is responsible?

On Windows, go to File > Options > Add-ins and disable COM Add-ins and Excel Add-ins through their respective Manage lists. Restart Excel and test, then re-enable add-ins one at a time if the issue disappears.

What should I check if only one workbook is affected?

Select the affected cell and inspect Format Cells and Home > Cell Styles. Compare it with another cell and test the same text in a blank workbook.