![]() |
Colors for Sheet Tabs
Why can't I set each sheet tab to a different color? This feature was
available in Lotus 123 V 97. You are going BACKWARDS. If I am wrong about this, how can it be done??? |
Colors for Sheet Tabs
Hi Max,
I use Excel 2003. When I have my spreadsheet open and all the sheet tabs are displayed at the bottom, I choose the sheet tab I wish to change, right click on it, and a menu pops up that offers me the option "Tab Colour". At first the colour just appears as an underline, but once you return it should colour the entire tab. I hope this helps. Karen "Max" wrote: Why can't I set each sheet tab to a different color? This feature was available in Lotus 123 V 97. You are going BACKWARDS. If I am wrong about this, how can it be done??? |
Colors for Sheet Tabs
I have Excel 2000 and no such option is available upon right-clicking the
sheet tab. So now what do I do? And please don't suggest buying the new version. "Karen" wrote: Hi Max, I use Excel 2003. When I have my spreadsheet open and all the sheet tabs are displayed at the bottom, I choose the sheet tab I wish to change, right click on it, and a menu pops up that offers me the option "Tab Colour". At first the colour just appears as an underline, but once you return it should colour the entire tab. I hope this helps. Karen "Max" wrote: Why can't I set each sheet tab to a different color? This feature was available in Lotus 123 V 97. You are going BACKWARDS. If I am wrong about this, how can it be done??? |
Colors for Sheet Tabs
Sometimes features just aren't available with older versions. (Colored tabs
started with Office 2002.) A big example is going to be with Office 12. It'll allow the users to create .pdf files without third-party software. Older versions can't - and there's no way Microsoft is going to retrofit the old versions. I'm not going to suggest you buy a new version - I understand that sometimes that's not an option. About the only thing I can recommend is that you try to accept what you can do and not fuss over things you can't. (If only I'd learn to heed my own advice.........) -- JoAnn Paules MVP Microsoft [Publisher] "Max" wrote in message ... I have Excel 2000 and no such option is available upon right-clicking the sheet tab. So now what do I do? And please don't suggest buying the new version. "Karen" wrote: Hi Max, I use Excel 2003. When I have my spreadsheet open and all the sheet tabs are displayed at the bottom, I choose the sheet tab I wish to change, right click on it, and a menu pops up that offers me the option "Tab Colour". At first the colour just appears as an underline, but once you return it should colour the entire tab. I hope this helps. Karen "Max" wrote: Why can't I set each sheet tab to a different color? This feature was available in Lotus 123 V 97. You are going BACKWARDS. If I am wrong about this, how can it be done??? |
All times are GMT +1. The time now is 01:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com