| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the tabs on an Exccel spreadsheet be shown in different colors
I have a workbook with about 50 worksheets. Can the bottom tabs be
color-coded, for easier usage? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different colors
In Excel 2003 (but not earlier versions): right click the tab and click Tab
Color best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PhoneMatt" wrote in message ... I have a workbook with about 50 worksheets. Can the bottom tabs be color-coded, for easier usage? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different co
Guess I'm out of luck. I'm using 2000. Right clicking was the first thing
that I tried, but with no success. Thanks for the quick answer. "Bernard Liengme" wrote: In Excel 2003 (but not earlier versions): right click the tab and click Tab Color best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PhoneMatt" wrote in message ... I have a workbook with about 50 worksheets. Can the bottom tabs be color-coded, for easier usage? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different colors
For the record, 2002 also
-- Don Guillett SalesAid Software "Bernard Liengme" wrote in message ... In Excel 2003 (but not earlier versions): right click the tab and click Tab Color best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PhoneMatt" wrote in message ... I have a workbook with about 50 worksheets. Can the bottom tabs be color-coded, for easier usage? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different colors
Bernard
Color tabs were introduced with 2002(XP) version. Gord On Wed, 3 Jan 2007 10:37:51 -0400, "Bernard Liengme" wrote: In Excel 2003 (but not earlier versions): right click the tab and click Tab Color best wishes |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different colors
Hi, Matt-
Right click on the tab and select "Tab Color", then select the color of your choice. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different co
Thanks, Dave, but I'm using 2000. Apparently this feature didn't hit Excel
until later versions. "Dave O" wrote: Hi, Matt- Right click on the tab and select "Tab Color", then select the color of your choice. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the tabs on an Exccel spreadsheet be shown in different colors
If you can't change the colors, I'd recommend making a 'table of contents'
sheet. You can add a named range to cell a1 of the sheet like "_toc" to make it easy to get to. Someone posted a script a while back to make it easy to set up too. Check out http://www.realezsites.com/bus/primitivesoftware Hope this helps. "PhoneMatt" wrote: I have a workbook with about 50 worksheets. Can the bottom tabs be color-coded, for easier usage? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting spreadsheet using tabs? | Excel Discussion (Misc queries) | |||
| On the keyboard, how do I toggle between tabs on a spreadsheet? | Excel Discussion (Misc queries) | |||
| Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) | |||
| Unable to format colors on part of a large spreadsheet | Excel Worksheet Functions | |||
| how to combine several tabs on a spreadsheet into a summary tab w. | Excel Discussion (Misc queries) | |||
Hybrid Mode
