Excel - how about allowing colored worksheet tabs for organizing

G

Guest

I use multiple worksheets to track costs in my field. Sometimes with
multiple worksheets it can get cumbersome to track sheets that are
interdependent on one another. I thought it would be nice to be able to
color the worksheet tabs in a workbook with similar colors so as to be able
to more easily track which sheets work with one another.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
D

David McRitchie

If your Excel is prior to Excel 2002 there is still something you can
do and I think it makes more sense than colored tabs.
Your could prefix the sheetname with a prefix like "f." or "k."
and then you sort your worksheet tabs.

More information on tab color, including window color
Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs

Macro SortAllSheets to sort your worksheet tabs
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

Now that I actually have XL XP, I colored a sheet tab (ugh) then
thought about sorting on color, but then I came to my senses and
relized that would mess up looking up things alphabetically, and now
I'm going to uncolor that sore thumb on worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top