Color-code worksheet tabs

C

Chip Pearson

Colleen,

This is possible only in Excel 2002 and later. In these version,
right-click the worksheet tab and choose Tab Color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

David McRitchie

Hi Colleen,

You can change the worksheet tab color in Excel 2002 and Excel 2003,
but not in earlier versions.
- Select the sheets you want to color by holding down the CTRL key and clicking the tabs.
- Right-click the sheet tab and then click Tab Color.
- Click the color you want, and click OK.

I believe the normal reason 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 See "sort sheet tabs" in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
 
D

Dave Peterson

With excel2002 and up. Just right click on the worksheet tab and there's an
option there.
 
Top