Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
djdima
 
Posts: n/a
Default 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   Report Post  
David McRitchie
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel should display tabs on multiple rows Kevin M Excel Worksheet Functions 6 March 8th 05 10:51 PM
MS Excel should allow you to change the color of the tabs or the . normvales Excel Worksheet Functions 1 February 10th 05 11:59 PM
Copying Tabs in Excel Christopher Anderson Excel Discussion (Misc queries) 1 January 5th 05 10:28 PM
In Excel can I move the tabs to the left side of the workbook? kit Excel Worksheet Functions 1 December 6th 04 08:15 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"