Can you change the font in sheet tabs?

Can you change the font in sheet tabs?

TIA for your help!

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)

"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:59E84060-ED37-4DF2-8AD1-1EE4F47618F2@microsoft.com...
> Can you change the font in sheet tabs?
>
> TIA 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

On Thu, 13 Jul 2006 08:23:02 -0700, Jennifer
<Jennifer@discussions.microsoft.com> wrote:

>Can you change the font in sheet tabs?
>
>TIA for your help!

Gord Dibben MS Excel MVP

Thanks all for your help!

"Gord Dibben" wrote:

> 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
>
> On Thu, 13 Jul 2006 08:23:02 -0700, Jennifer
> <Jennifer@discussions.microsoft.com> wrote:
>
> >Can you change the font in sheet tabs?
> >
> >TIA for your help!
>
> Gord Dibben MS Excel MVP
>