ExcelBanter - How do you change the font on workbook pages?

To change default font for all new workbooks.

ToolsOptionsGeneralStandard Font.

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.

Win98 as example...

Right-click on desktop and select Appearance tab

WinXP AppearanceAdvanced

"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 Wed, 6 Dec 2006 07:42:01 -0800, Data across workbook pages
wrote:

I am making a workbook in Excel and I would like to change the font and font
size of the tabs in my workbook, can this be done?

Gord Dibben MS Excel MVP