how do i change (or add) colour to the worksheet tabs (in excel)
 

I used to be able to do this, but: how do you change the colour of the
worksheet tabs in Excel? I'm working with a whack of tabs and would like to
give each one a different colour - but I can't for the life of me remember
how to do it.

Thanks!

AL

how do i change (or add) colour to the worksheet tabs (in excel)
 

Right click sheet tab and select tab colour, of course it was implemented in
2002 I think so if you use an earlier version it won't work



--
Regards,

Peo Sjoblom



"french-girl" wrote in message
...
I used to be able to do this, but: how do you change the colour of the
worksheet tabs in Excel? I'm working with a whack of tabs and would like
to
give each one a different colour - but I can't for the life of me remember
how to do it.

Thanks!

AL

how do i change (or add) colour to the worksheet tabs (in excel)
 

Hi

The feature came in with Xl2002, so provided you are using that version
or later, then right click on sheet tabTab colour.

--
Regards

Roger Govier


"french-girl" wrote in message
...
I used to be able to do this, but: how do you change the colour of the
worksheet tabs in Excel? I'm working with a whack of tabs and would
like to
give each one a different colour - but I can't for the life of me
remember
how to do it.

Thanks!

AL