by Allen Wyatt
(last updated January 18, 2020)
Michael just purchased a new laptop with Office 365 installed. When he selects a range of cells, the sum, average, and count appear in the Status Bar. However, the font size is so large that the right-most numbers are not shown completely. Michael wonders how he can decrease the font size of the information displayed on the Status Bar so he can see it all.
Before getting into making changes to the font, you might want to make sure that your Excel program window is wide enough to display all the information you are trying to display in the Status Bar. If not, then simply make the program window wider and your information should all appear as desired.
You can also, if desired, change what is displayed in the Status Bar. Just right-click a blank area on the Status Bar and you can select which stats show up there. If you display fewer stats, then there is a greater likelihood that you'll be able to see what you want to see.
If you still want to change the font size, this is not controlled within Excel. The program relies on the system fonts defined by Windows itself. This can be a bit involved, as it depends on the version of Windows you are using on your system and how you want to adjust the font size. One way to do it is to scale the fonts, as described in this tip:
Once you make changes in Windows, you may need to close and open Excel again in order to see the effects of those changes. Understand that any changes you make in Windows will affect all your other programs, as well. So, it may take a bit of testing on your part to get the settings the way that works best for all of your programs.
If you want to change the system fonts entirely (perhaps to a narrower font), then you'll need to rely on some hacks to the Windows Registry. Those are described at this website, for Windows 10:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13727) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Some people like zero values displayed; others do not. Excel allows you to easily turn the display on or off for a single ...Discover More
Excel normally refers to columns as A, B, C, etc. It also has a referencing format that allows columns to be referred to ...Discover More
When entering data in a worksheet, Excel tries to figure out how your entry can best be shown on the screen. When it ...Discover More