If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Allow "stacking" or "grouping" of tabs in excel
Just a suggestion.
When working with large multi-tab excel files, it would be nice to be able to arrange tabs in a meaningful way - grouping or stacking or inserting spacers. Also, tab shapes and fonts should be flexible. ---------------- 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/comm...ic.excel.setup |
#2
|
|||
|
|||
I guess Microsoft would suggest you go with Excel 2002 with colored tabs.
Multiple layers of tabs is not available in any version. My feeling is that colored tabs have nothing or very little to do with organization. You can name your tabs so that they can be organized by sorting them. ie. k.key words, k.shortcuts You can sort your worksheet tabs with a macro, see SortALLsheets SortAllSheets -- The following code will sort sheet tabs (#sortallsheets) within "Build Table of Contents, similar listings, working with Hyperlinks" http://www.mvps.org/dmcritchie/excel...#sortallsheets You can also rightclick on the navigation arrows to the left of the worksheet tabs to see a list of worksheet tabs if you have only a few, or on the "More sheets" within that list to see them all -- it helps if you've sorted your worksheet tabs as above, and you can use a macro to bring up the "more sheets" in a more direct fashion.. http://www.mvps.org/dmcritchie/excel/dialog.htm using a suggestion from Chip Pearson. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "djdima" wrote in message ... Just a suggestion. When working with large multi-tab excel files, it would be nice to be able to arrange tabs in a meaningful way - grouping or stacking or inserting spacers. Also, tab shapes and fonts should be flexible. ---------------- 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/comm...ic.excel.setup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel stack tabs in groups, less scrolling L2R, hovering over gro. | Stephen Robb | General Discussion | 1 | February 18th, 2005 11:48 PM |
excel macros truncating tabs for hidden columns. | SharanS | General Discussion | 0 | February 17th, 2005 05:05 AM |
OutputTo: Creating Tabs In Excel | smeghead | Setting Up & Running Reports | 0 | December 15th, 2004 12:39 AM |
Excel 2000 export to Tab deliminated text file - how to control tabs at end of line | BeamGuy | General Discussions | 1 | June 4th, 2004 02:17 PM |
Excel Worksheet Tabs | [email protected] | Worksheet Functions | 2 | October 18th, 2003 06:36 AM |