Fix Text Formatting Changes in the Excel Formula Bar
Question details
The user wants to understand and troubleshoot apparent text formatting changes when selecting text 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.
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.
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.
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.
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.
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.
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.

Check Excel Add-ins, Updates, and Display Settings
Use these checks when the behavior occurs in multiple workbooks or disappears in Windows Safe Mode.
Inspect Formatting in the Affected Workbook
Use this approach if the issue appears only in one workbook or cell.
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.

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.




