Excel 365 Formula Bar font is different BUT only when displaying a formula

Anonymous
2024-03-18T02:31:32+00:00

Dear Excel MVP,

Some months ago something changed in my Excel 365 Formula Bar display. The default font for new workbooks has always been Arial 8...no change there. The formula bar for text values displays correctly Arial 8 and if I click on the formula bar I can change the font as required. However, for any cell containing a formula the font displayed in the formular bar is not Arial 8, but appears to be Consolas 8. See the screen clip below. In addition if I click on the formula bar the font and size are greyed out and can't be changed.

This bug appeared following an Office 365 update. I am a Microsoft 365 Insider and all my software is 100% up-to-date.

Can you please advise what the problem is and how to resolve it?

Cheers,
Geoff Frost

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2024-06-23T14:53:55+00:00

Hi David,

First of all, many of the participants of this thread think that this is a bug. Unfortunately, it isn't. As it was announced in this Microsoft Excel Blog las year:

https://techcommunity.microsoft.com/t5/excel-blog/excel-s-formula-bar-gets-a-new-look/ba-p/3902462

There are only two problems with monospaced Consolas in the formula bar: that it is monospaced, and that it is Consolas.

I found the example in the linked article really biased, hence frustrating: what percentage of Excel users write formulas like that as the dominant part of their work crying out for monospaced character? Formulas without numbers and cell references? They are arguing with programming ****, but Excel formula bar is in most of the cases not a programming interface.

I use Excel, Excel VBA, Power Pivot on a regular basis, I write short and long formulas, and I never missed this trash. On the contrary, I really hate it!

The formulas became longer and this new spacing breaks words into letters. Consolas is a disaster, its accentuated slashed zero attracts the look, but that only distracts attention from grasping the formula's meaning. The 3 and 5 are ugly, the latter is harder to distinguish from B or E than by using any other character. Functions with . separation will be spaced before and after the . , so instead of keeping together the function name as an undivided expression, it splits it up into 3 parts.

I discovered recently that Google Sheets use monospaced font in the formula bar, but it is not Consolas: the zero is almost the same, but the other numbers are more readable.

Was Microsoft afraid that users would switch to Google Sheets because of this feature?

Dénes

Was this answer helpful?

100+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2024-09-30T02:20:32+00:00

This has been fixed!!!!

You can disable it under Options > Formulas > Use monospace font for all formulas. 

Excel’s Formula Bar Gets a New Look (microsoft.com)

Was this answer helpful?

70+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2024-06-23T19:33:28+00:00

Thanks for this Dénes! So they have simply dropped this **** on us and don't even make it optional.

Also good to know for the future that this forum is only for venting, as nobody from Microsoft has said a word.

Thanks again!

Was this answer helpful?

30+ people found this answer helpful.
0 comments

70 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-18T06:27:17+00:00

    Hi Kevin,

    Thanks for the prompt reply.

    My Excel version is: Microsoft® Excel® for Microsoft 365 MSO (Version 2403 Build 16.0.17425.20058) 64-bit

    It does not have the "Show formula bar" option. See the screen clip.

    I opened Excel in Safe mode and the issue did seem to go away. Formulae in the Formula Bar aren't greyed out, though in Safe mode I can't set the Normal font to Arial 8. I disabled all non Excel Add-ins and restarted Excel normally, but no good.

    Further information. I'm sure that the problem occurred following a recent Office 365 update. Also the exact same problem is occurring on both my laptop and desktop machines. These machines run the same Office 365 software. Any further thoughts?

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2024-06-04T20:22:42+00:00

    Hello, GeoffreyFrost1. I raised this concern on our tech community to help us with it. Let's wait for their fix and I hope they can provide an update for our Microsoft Office Excel soon. Please let me know if this helped us to answer your concern. Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below. Kind regards, Kevin

    Seeing this is almost current had the exact same font show up in a regular Office 2019 Excel today as in the first post. Definitely out of nowhere though. Got any valid answer?

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments