Changing Color of Worksheet Tab

G

Gord Dibben

Only in Excel 2002 and 2003.

Right-click on sheet tab and "Tab Color".

Gord Dibben Excel MVP
 
S

shortstuff245

To change the color of a worksheet tab click the appropriate tab and then right-click and a message box will pop up. Click "Tab Color" and a pallate of colors will pop up. Simply pick the color and click OK and then just select a cell in the worksheet and the tab will now be the color you picke.
 
D

David McRitchie

Hi Don,
Even though you do not have Excel 2002 or later there are things you can
do to organize your tabs that probably make a lot more sense than color.

I believe the normal reason in wanting to color tabs is to provide an organization to them.
You can sort sheet tabs with a macro. You can enhance your sorted arrangement
by preceding the sheet tab with some less conspicuous small letters. i.e.
k.FunctKeys, k.ShortCutKeys
More information on alternatives in ....

Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
 
D

Don

Thanks for the hints David!

This whole exercise was the result of seeing colored tabs somewhere and then
having some time to hack on my machine. I had gone down the "right-click"
path, but it didn't find anything related to color. Not surprising since I
have Excel 2000. Then I thought it might be some VBA magic and tried some
things there. But, as you show in the URL you posted, the property (both in
"right-click" and VBA!) is available in Excel 2002 and greater.

Maybe time for an upgrade! :)

Don




David McRitchie said:
Hi Don,
Even though you do not have Excel 2002 or later there are things you can
do to organize your tabs that probably make a lot more sense than color.

I believe the normal reason in wanting to color tabs is to provide an organization to them.
You can sort sheet tabs with a macro. You can enhance your sorted arrangement
by preceding the sheet tab with some less conspicuous small letters. i.e.
k.FunctKeys, k.ShortCutKeys
More information on alternatives in ....

Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Don said:
Thanks everyone!
Since I have MS Excel 2000, no wonder I couldn't find it!!
Click to expand...
Click to expand...
 
Top