How do I color code worksheet tabs please?

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
 
F

FSt1

hi
right click on the tab then from the popup, click tab color. pick your color.

regards
FSt1
 
J

John

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
 
G

Gord Dibben

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

Need help modifying code 0
How to use/create code in MS Word to calculate age? 0
How to set tabs in work document 0
How do I convert shading to highlighting for specific colors 8
how do I change the color on a worksheet tab using excel mac 2004 1
emailing worksheet... 1
Default Color in MS 2003 Excel Tabs 3
New computer, how do i move outlook 365 ENTIRELY? 0

Top