Can the tabs on an Exccel spreadsheet be shown in different colors
 

I have a workbook with about 50 worksheets. Can the bottom tabs be
color-coded, for easier usage?

Can the tabs on an Exccel spreadsheet be shown in different colors
 

In Excel 2003 (but not earlier versions): right click the tab and click Tab
Color
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PhoneMatt" wrote in message
...
I have a workbook with about 50 worksheets. Can the bottom tabs be
color-coded, for easier usage?

Can the tabs on an Exccel spreadsheet be shown in different colors
 

Hi, Matt-
Right click on the tab and select "Tab Color", then select the color of
your choice.

Can the tabs on an Exccel spreadsheet be shown in different co
 

Guess I'm out of luck. I'm using 2000. Right clicking was the first thing
that I tried, but with no success. Thanks for the quick answer.

"Bernard Liengme" wrote:

In Excel 2003 (but not earlier versions): right click the tab and click Tab
Color
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PhoneMatt" wrote in message
...
I have a workbook with about 50 worksheets. Can the bottom tabs be
color-coded, for easier usage?

Can the tabs on an Exccel spreadsheet be shown in different co
 

Thanks, Dave, but I'm using 2000. Apparently this feature didn't hit Excel
until later versions.

"Dave O" wrote:

Hi, Matt-
Right click on the tab and select "Tab Color", then select the color of
your choice.

Can the tabs on an Exccel spreadsheet be shown in different colors
 

For the record, 2002 also

--
Don Guillett
SalesAid Software

"Bernard Liengme" wrote in message
...
In Excel 2003 (but not earlier versions): right click the tab and click
Tab Color
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PhoneMatt" wrote in message
...
I have a workbook with about 50 worksheets. Can the bottom tabs be
color-coded, for easier usage?

Can the tabs on an Exccel spreadsheet be shown in different colors
 

Bernard

Color tabs were introduced with 2002(XP) version.


Gord

On Wed, 3 Jan 2007 10:37:51 -0400, "Bernard Liengme"
wrote:

In Excel 2003 (but not earlier versions): right click the tab and click Tab
Color
best wishes

Can the tabs on an Exccel spreadsheet be shown in different colors
 

If you can't change the colors, I'd recommend making a 'table of contents'
sheet. You can add a named range to cell a1 of the sheet like "_toc" to make
it easy to get to. Someone posted a script a while back to make it easy to
set up too.

Check out http://www.realezsites.com/bus/primitivesoftware

Hope this helps.

"PhoneMatt" wrote:

I have a workbook with about 50 worksheets. Can the bottom tabs be
color-coded, for easier usage?