work sheet names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to make the tab with the worksheet names different colors? Most of my workbooks have many sheets, having each one a different color would make picking the correct one much easier.
 
Hi
if you have Excel 2002+ just right click on the tab name and choose
'color'.

Prior versions: no chance
 
Only in XL2002 and above.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

carrera said:
Is there a way to make the tab with the worksheet names different colors?
Click to expand...
Most of my workbooks have many sheets, having each one a different color
would make picking the correct one much easier.
 
Carrera,

That's depending of your version of Excel.
In Excel97 it isn't available. In XL XP : right click on the tab and select
Tab color...

I'm not sure but I think that available from XL2002 onwards.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

carrera said:
Is there a way to make the tab with the worksheet names different colors?
Click to expand...
Most of my workbooks have many sheets, having each one a different color
would make picking the correct one much easier.
 
Back
Top