software

Is there a way to change the default font for a worksheet tab? That is,
let's say that for some reason I wanted to use 8 point Verdana as opposed to
whatever the default is. How would I go about changing that?

Alternatively: is there a way to increase the number of characters allowed
in a worksheet tab name?

You cannot change the font of the tabs alone.

30 characters per tab is the limit.

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 Appearancegt;Advanced)

quot;Itemquot; 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 Excel MVP

On Wed, 21 Dec 2005 07:55:03 -0800, quot;1940LaSallequot;
gt; wrote:

gt;Is there a way to change the default font for a worksheet tab? That is,
gt;let's say that for some reason I wanted to use 8 point Verdana as opposed to
gt;whatever the default is. How would I go about changing that?
gt;
gt;Alternatively: is there a way to increase the number of characters allowed
gt;in a worksheet tab name?

So what this means is that I'm locked in with 30 characters for any Excel
worksheet tab, the size of the tab notwithstanding--and that there is no way
to tweak the tabs to make that, say, 40 characters?

If so.....drat. I have some files with rather long chemical names where
more than 30 characters would be helpful.

quot;Gord Dibbenquot; wrote:

gt; You cannot change the font of the tabs alone.
gt;
gt; 30 characters per tab is the limit.
gt;
gt; You can change the size of the tabs.
gt;
gt; This is a function of your Windows Display Properties.
gt;
gt; The size of the sheet tabs are governed by the setting for Scrollbars in
gt; Windows Display Appearance. Mine are at 18. Start there and work your way
gt; up or down. The font will increase or decrease with the size of sheet tabs.
gt;
gt; Win98 as example...
gt;
gt; Right-click on desktop and select Appearance tab
gt;
gt; WinXP Appearancegt;Advanced)
gt;
gt; quot;Itemquot; drop down select Scrollbar
gt;
gt; Change setting to Taste
gt; Apply
gt; OK
gt;
gt; Depending upon your settings, you may have to re-boot to see the changes.
gt;
gt; Also note: this is a Global change and will affect all Applications.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Wed, 21 Dec 2005 07:55:03 -0800, quot;1940LaSallequot;
gt; gt; wrote:
gt;
gt; gt;Is there a way to change the default font for a worksheet tab? That is,
gt; gt;let's say that for some reason I wanted to use 8 point Verdana as opposed to
gt; gt;whatever the default is. How would I go about changing that?
gt; gt;
gt; gt;Alternatively: is there a way to increase the number of characters allowed
gt; gt;in a worksheet tab name?
gt;

Nope, max size is 32 characters so you have to be inventive coming up with
the names--

Regards,

Peo Sjoblomquot;1940LaSallequot; gt; wrote in message
...
gt; So what this means is that I'm locked in with 30 characters for any Excel
gt; worksheet tab, the size of the tab notwithstanding--and that there is no
way
gt; to tweak the tabs to make that, say, 40 characters?
gt;
gt; If so.....drat. I have some files with rather long chemical names where
gt; more than 30 characters would be helpful.
gt;
gt; quot;Gord Dibbenquot; wrote:
gt;
gt; gt; You cannot change the font of the tabs alone.
gt; gt;
gt; gt; 30 characters per tab is the limit.
gt; gt;
gt; gt; You can change the size of the tabs.
gt; gt;
gt; gt; This is a function of your Windows Display Properties.
gt; gt;
gt; gt; The size of the sheet tabs are governed by the setting for Scrollbars in
gt; gt; Windows Display Appearance. Mine are at 18. Start there and work your
way
gt; gt; up or down. The font will increase or decrease with the size of sheet
tabs.
gt; gt;
gt; gt; Win98 as example...
gt; gt;
gt; gt; Right-click on desktop and select Appearance tab
gt; gt;
gt; gt; WinXP Appearancegt;Advanced)
gt; gt;
gt; gt; quot;Itemquot; drop down select Scrollbar
gt; gt;
gt; gt; Change setting to Taste
gt; gt; Apply
gt; gt; OK
gt; gt;
gt; gt; Depending upon your settings, you may have to re-boot to see the
changes.
gt; gt;
gt; gt; Also note: this is a Global change and will affect all Applications.
gt; gt;
gt; gt;
gt; gt; Gord Dibben Excel MVP
gt; gt;
gt; gt; On Wed, 21 Dec 2005 07:55:03 -0800, quot;1940LaSallequot;
gt; gt; gt; wrote:
gt; gt;
gt; gt; gt;Is there a way to change the default font for a worksheet tab? That
is,
gt; gt; gt;let's say that for some reason I wanted to use 8 point Verdana as
opposed to
gt; gt; gt;whatever the default is. How would I go about changing that?
gt; gt; gt;
gt; gt; gt;Alternatively: is there a way to increase the number of characters
allowed
gt; gt; gt;in a worksheet tab name?
gt; gt;
32?

lt;vbggt;

Peo Sjoblom wrote:
gt;
gt; Nope, max size is 32 characters so you have to be inventive coming up with
gt; the names
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;1940LaSallequot; gt; wrote in message
gt; ...
gt; gt; So what this means is that I'm locked in with 30 characters for any Excel
gt; gt; worksheet tab, the size of the tab notwithstanding--and that there is no
gt; way
gt; gt; to tweak the tabs to make that, say, 40 characters?
gt; gt;
gt; gt; If so.....drat. I have some files with rather long chemical names where
gt; gt; more than 30 characters would be helpful.
gt; gt;
gt; gt; quot;Gord Dibbenquot; wrote:
gt; gt;
gt; gt; gt; You cannot change the font of the tabs alone.
gt; gt; gt;
gt; gt; gt; 30 characters per tab is the limit.
gt; gt; gt;
gt; gt; gt; You can change the size of the tabs.
gt; gt; gt;
gt; gt; gt; This is a function of your Windows Display Properties.
gt; gt; gt;
gt; gt; gt; The size of the sheet tabs are governed by the setting for Scrollbars in
gt; gt; gt; Windows Display Appearance. Mine are at 18. Start there and work your
gt; way
gt; gt; gt; up or down. The font will increase or decrease with the size of sheet
gt; tabs.
gt; gt; gt;
gt; gt; gt; Win98 as example...
gt; gt; gt;
gt; gt; gt; Right-click on desktop and select Appearance tab
gt; gt; gt;
gt; gt; gt; WinXP Appearancegt;Advanced)
gt; gt; gt;
gt; gt; gt; quot;Itemquot; drop down select Scrollbar
gt; gt; gt;
gt; gt; gt; Change setting to Taste
gt; gt; gt; Apply
gt; gt; gt; OK
gt; gt; gt;
gt; gt; gt; Depending upon your settings, you may have to re-boot to see the
gt; changes.
gt; gt; gt;
gt; gt; gt; Also note: this is a Global change and will affect all Applications.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Gord Dibben Excel MVP
gt; gt; gt;
gt; gt; gt; On Wed, 21 Dec 2005 07:55:03 -0800, quot;1940LaSallequot;
gt; gt; gt; gt; wrote:
gt; gt; gt;
gt; gt; gt; gt;Is there a way to change the default font for a worksheet tab? That
gt; is,
gt; gt; gt; gt;let's say that for some reason I wanted to use 8 point Verdana as
gt; opposed to
gt; gt; gt; gt;whatever the default is. How would I go about changing that?
gt; gt; gt; gt;
gt; gt; gt; gt;Alternatively: is there a way to increase the number of characters
gt; allowed
gt; gt; gt; gt;in a worksheet tab name?
gt; gt; gt;

--

Dave Peterson