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"
    Else
        Application.StandardFontSize = "24"
    End If
 
End Sub

 

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