Color-code worksheet tabs

  • Thread starter Thread starter colleen godden
  • Start date Start date
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
 
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
 
With excel2002 and up. Just right click on the worksheet tab and there's an
option there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Macro to hide worksheet based upon text in the name 5
Any Way to Enlarge the Tabs? 1
Excel VBA 1
Tab color? 3
Grouping with protected sheets (multiple sheets) 0
how do I change the color on a worksheet tab using excel mac 2004 2
I need to know how to color code tabs on the Excel worksheets 3

Back
Top