Better Excel Presentations:
Increase Font Size of Formula Bar
Imagine the following scenario: You’re in the audience of a presentation and the speaker is displaying a spreadsheet on a television or projector screen. The screen is full of facts, figures, and formulas.
Sitting in the back of the room, you ask, “Excuse me. I can’t read your data. Could you zoom in please?”
This is an easy request to fulfill… except for the Formula Bar.
How can we make the font size larger in the Formula Bar? Here’s the trick.
Increasing the Font Size
of the Formula Bar
The zoom control in Excel will increase the magnification of the cells and their contents but not the text in the Formula Bar or Name Box.
This can present challenges in a presentation or a training environment.
If you’ve ever tried to display a complicated formula in front of a group, and the only way to show the formula was through the Formula Bar, most of your audience will likely not be able to read the formula due to the small font size.
The solution is to change the default font size in Excel.
Step 1 – Open the Excel Options by selecting the File tab to access the Backstage view.
Step 2 – In the lower-left side of the screen, select Options.
Step 3 – In the Excel Options dialog box, in the General section there is a subsection labeled “When creating new workbooks”. Change the control labeled Font Size from the default size of 11 points to a larger value, like 16. This may require a bit of experimenting between different sizes to find the size you prefer the most.
After you click OK to close the Excel Options dialog box you will be presented with a notification requesting you close and restart Excel for the change to take effect.
Step 4 – Close Excel and then reopen the file you were examining prior to the font change.
Step 5 – Click on a cell that holds a formula and examine the Formula Bar and Name Box.
Notice how much easier the formula is to read, even from the most distant seats in the room?
The font sizes for the existing file will remain unchanged.
When you create a new file, the default font size for the entire document will now be set to the value you selected in the Excel Options dialog box.
This may be undesirable. Remember to set the default font size back to 11 points (or whatever font size you prefer) once your presentation is complete.
During the presentation, it’s so much easier for your audience to read your formulas with this simple modification.
Excel Dashboards that Inform & Impress