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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2025-01-21T14:27:19+00:00

    I hate this new monospace typeface and was happy to see a solution here but that option is not available in my Excel M365 (Win11)

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-12-07T02:56:55+00:00

    I don't understand why Microsoft adding such silly tiny changes (formula font) in Excel. What is the value that you added? was it simply your development team running out of improvement so came up with this font change idea?

    Honestly, the Monospace formula font look annoying, I hope you noticed this after seeing so many people wanted to change it back.

    I am a 30 years Excel user, started using it since I was 16 years old. Lately I found all the "enhancements" are nonsense little twitches that adds no value. Rather than spending time on rolling out things like formula font update, please put in your time & effort into something more significant, or otherwise simply don't need any updates.

    Hope you can take this feedback positively.

    Was this answer helpful?

    0 comments