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????

right click on the tab and select tab color

"peaspud" wrote:

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????

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 :-)
----------------------------------------------------------------------------

"peaspud" wrote in message
...
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????

On Mon, 28 Feb 2005 10:59:02 -0800, "peaspud"
wrote:

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