Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the font size inside a sheet tab?
When having multiple sheet tabs is required, I would like to shrink the font
size in order to 'see' all the tabs without having to scrool left or right. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the font size inside a sheet tab?
Change the Normal Style to suite your needs
-- Gary''s Student - gsnu200820 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the font size inside a sheet tab?
You cannot change the font of the tabs alone.
You can change the size of the tabs. This is a function of your Windows Display Properties. The size of the sheet tabs are governed by the setting for Scrollbars in Windows Display Appearance. Mine are at 18. Start there and work your way up or down. The font will increase or decrease with the size of sheet tabs. Right-click on your Desktop and PropertiesAppearanceAdvanced "Item" drop down select Scrollbar Change setting to Taste Apply OK Depending upon your settings, you may have to re-boot to see the changes. Also note: this is a Global change and will affect all Applications. Having said all that.................it is far easier to right-click on one of the sheet navigation arrows to get a 15 sheet listing and "more". Another option................................ You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's site. Sorts as well as navigates. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Tue, 16 Dec 2008 06:56:01 -0800, rgranell wrote: When having multiple sheet tabs is required, I would like to shrink the font size in order to 'see' all the tabs without having to scrool left or right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
how to change font size of datalabels of two charts in a sheet | Charts and Charting in Excel | |||
How can I change the font size on an Excel sheet tab? | Excel Discussion (Misc queries) | |||
Change font size on sheet tabs | Excel Discussion (Misc queries) |