How do I color code worksheet tabs please?

  • Thread starter Thread starter thenamesjack
  • Start date Start date
T

thenamesjack

I am creating a multi-sheet workbook and want to color code the tabs into
three or four color groups. Can I do this through menus because I am not a
programmer?
Thanks
 
hi
right click on the tab then from the popup, click tab color. pick your color.

regards
FSt1
 
Hi Jack
To colour your Tabs, right click on the tab and select > Tab Colour>
You have around 50 colours to choose from.
HTH
John
 
To color more than one a time, select the ones to color blue by CTRL + Click
then right-click on the active tab and choose your color.


Gord Dibben MS Excel MVP
 

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
Tab color? 3
Color changing VB Code 0
How to filter rows data based on background color of individual cells 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
How can I activate tab colors? 1
Excel 200 - changing tab colors 1
Changing worksheet tab colors 1

Back
Top