Written by Allen Wyatt (last updated September 25, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
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:
https://windows.tips.net/T165
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:
https://www.windowscentral.com/how-change-default-system-font-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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
When your screen doesn't behave as you expect, it could be because of the Scroll Lock on your system. Here's what to check.
Discover MoreBy default, Excel shows row numbers at the left side of your program window. If you cannot see the row numbers, there are ...
Discover MoreWhen using alternative pointing devices with a computer (such as a laptop), Excel may not always behave in helpful ways. ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments