Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do you change the font on workbook pages?

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Font Colour and Background If Q [email protected] Excel Worksheet Functions 11 September 27th 06 05:59 PM
How do I change the font color based on results of an IF stateme MKLeisure Excel Worksheet Functions 2 December 16th 05 03:53 PM
Change default font in exising workbooks Jeffry Excel Discussion (Misc queries) 2 July 5th 05 08:23 PM
change defaut workbook font color Ak_Deeg Excel Discussion (Misc queries) 1 February 13th 05 01:43 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"