A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Allow "stacking" or "grouping" of tabs in excel



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2005, 01:16 AM
djdima
external usenet poster
 
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  
Old May 27th, 2005, 03:07 AM
David McRitchie
external usenet poster
 
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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:40 PM.


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