Increasing Excel Formula Bar Font Size

Good for training

I recently saw a good post on Linkedin from Leila Gharani MVP on increasing the Excel Formula Bar font size. It seems useful for training, so I wrote a simple macro to simplify the process.

The macro changes the default font size for Excel (this includes the Formula Bar) you have to close Excel and re-open to see the change.

You need to reset it back to normal size once you no longer need the large size. The macro toggles between 12 and 24. See image below for the difference.

Sub Change_Default_Font()
'You need to close Excel and re-open
' for the change to take effect
    If Application.StandardFontSize = "24" Then
        Application.StandardFontSize = "12"
        Application.StandardFontSize = "24"
    End If
End Sub


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.