Can you change the font in sheet tabs?

[Jennifer]

Can you change the font in sheet tabs?

TIA for your help!

 

[Bob Phillips]

Not in Excel, but you can via Windows Control Panel, Display Settings, but
this will affect many other parts of your system.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Gord Dibben]

Jennifer

You can change the size of the tabs but not the font type.

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.

Win98 as example...

Right-click on desktop and select Appearance tab

WinXP Appearance>Advanced)

"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.


Gord Dibben MS Excel MVP

Can you change the font in sheet tabs?

TIA for your help!

Gord Dibben MS Excel MVP

 

[Jennifer]

Thanks all for your help!

Jennifer

You can change the size of the tabs but not the font type.

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.

Win98 as example...

Right-click on desktop and select Appearance tab

WinXP Appearance>Advanced)

"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.


Gord Dibben MS Excel MVP



Gord Dibben MS Excel MVP