How do i get coloured tabs in worsheet for excel

[Guest]

IM using Excel 200 and i am doing worksheets for work.To make them easier for
me to I.D. i want each sheet to correspond with the relervent coloured floor
we use.
i.e. Floor 1=Blue, Floor 2=Red and so on.Im sure i managed to get coloured
tabs on a previous Excel but cant do it on present one. Can anybody help????

 

[Guest]

right click on the tab and select tab color

 

[Ken Wright]

Excel 2002 and up only. Right click and choose Tab Colour.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

IM using Excel 200 and i am doing worksheets for work.To make them easier for
me to I.D. i want each sheet to correspond with the relervent coloured floor
we use.
i.e. Floor 1=Blue, Floor 2=Red and so on.Im sure i managed to get coloured
tabs on a previous Excel but cant do it on present one. Can anybody

help????

 

[Don S]

IM using Excel 200 and i am doing worksheets for work.To make them easier for
me to I.D. i want each sheet to correspond with the relervent coloured floor
we use.
i.e. Floor 1=Blue, Floor 2=Red and so on.Im sure i managed to get coloured
tabs on a previous Excel but cant do it on present one. Can anybody help????

I don't think that was an option in Excel 2000 - at least mine didn't
do it. Office XP was the first to introduce colored tabs. I upgraded
to Office 2003 & it is there.

Don S