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.