logo ASAP Utilities
HomeExcel tipsHow to change the font size on the sheet tabs

Excel tip: How to change the font size on the sheet tabs

Date: 30 october 2006

You cannot change the font size of the sheet-tabs in Excel. However you can adjust the settings in Windows to change this, but that will also affect other application.
In Windows XP (but similar in other Windows versions):
  • Right-click on an empty spot on you desktop and choose "Properties".
  • In the "Display Properties" dialog choose "Appearance" and then click on the "Advanced" button.
    Windows Display Properties
  • In the "Advanced Appearance" dialog choose the item "Scrollbar" and adjust the size.
    Display Properties advanced appearance scrollbar
On my computer the default value is 17. If you increase that number the sheet-tabs in Excel will become larger. A lower number will show smaller sheet-tabs. Adjust the number to fit your needs. Depending on your settings, you may have to restart your computer to see the changes.
Example default size:
Sheet tab size default
Example smaller size:
Sheet tab size smaller
The benefit of the smaller size is that more information can be displayed at the same time.



« back

Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2020 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook