Changing Font Size of Just the Formula Bar

I just got back from a whirlwind week of live training events. The most exciting one was the live Xcelsius training we did in Miami. We had a blast, as we always do at our live events. I was on my game – of course – and everyone walked away with coffers full of new techniques.


During my live training events, I have gotten into the habit of using a trick I learned from John (a Senior VP at Ernst &Young) a few months ago.

With this trick, I can increase the font of just the Formula bar. Like this:


This technique has proven to be extremely useful in live training scenarios where students in the back of the room struggle to see the formulas that are thrown up on the screen.

Here, I can make the Font size huge so all the students can see.


I know what you’re thinking: “Why isn’t the rest of the workbook huge too (i.e. column references, row references). Well the secret is if you increase the workbook font properties, then open an already existing workbook, only the formula bar actually takes on the new font properties.


Try it yourself.

In Excel, open up the Excel options and go to the section called ‘When creating new workbooks’.

Then change the Font size to any size you’d like.

Now press the OK button and close out Excel.


The next time you open Excel, everything will be BIG.


However…….If you open an Excel document that was created and saved in normal size, only the formula bar is big.



Now…. I personally wouldn’t use this trick in my everyday work. Constantly changing font sizes in my Excel workbooks seems silly.

However, when I put on my live training events, I use this trick all the time. It’s my way of giving back to the sight-challenged Excel analyst community.


Apart from the accidental functionality I’ve found in this strange glitch in Workbook Font sizing, this behavior in Excel does feel a bit like a bug. One would think the formula bar would remain normal size (like the other interface components) when opening up an exisitng workbook. Instead, the Formula bar is the only interface component that takes on the new Workbook font properties.


Bug or not, I’ve adopted this freakish behavior as my trick.

18 thoughts on “Changing Font Size of Just the Formula Bar

  1. Erin

    Yes, it works in Excel 2003.

    Go to Tools/Options and select the General tab. On the right about halfway down there are two dropdowns: one for font and a second for size.

    Make your selections and then close and restart Excel.

  2. sam

    “It’s my way of giving back to the sight-challenged Excel analyst community”

    MS already took care of them in 2007/2010 – why else do you think that the size of the Paste button increased by almost 2.5 times compared to the earlier versions.

    MS also catered to the mentally challenged users – by spelling out the Paste button – so that users would not confuse it with the Copy button ….

  3. Lynda

    RE: “MS already took care of (the sight-challenged Excel analyst community)”

    Only fair, since it’s their fault I became sight-challenged in the 1st place!

    Nice tip – that’s going to come in handy

  4. Mark

    “Senior VP at Ernst & Young”? You might want to check with your friend John. We don’t have VPs or SVPs here.

    Cool trick nonetheless though.

  5. Nan Todd

    This is great! We just went to windows 7 in our office and everything – including the formula bar – seems too small to read comfortably – now I can finally see it!

  6. John Durkee

    Do you know if this can be done in WordPerfect — increasing the font size of the table formula bar?
    Thanks for anything you care to contribute!

  7. IronHerder

    I found that I need this trick after I spent 30 minutes debugging a simple formula. Turns out I had used an ‘S’ instead of a ‘$’. Thanks, thanks, and more thanks.

  8. Pingback: Excel Formula Bar

Leave a Reply

Your email address will not be published. Required fields are marked *