Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default Is there any way to create a folder structure for tabs in a workbo

I work with spreadsheets with many tabs, and it would be nice if I could see
only groupings of tabs at the bottom...and then do something like double
click on a grouping to see all the tabs. Example: tabs a,b,c,...1,2,3...;
but on the bottom I would only see folder tabs "alphabet" and "numbers"...and
then I could double click on one of them to see the sub-tabs. Is this
possible?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Is there any way to create a folder structure for tabs in a workbo

Creating a folder structure for tabs in Microsoft Excel
  1. Right-click on any of the existing tabs at the bottom of the workbook and select "New Group" from the context menu.
  2. A new group tab will appear at the bottom of the workbook. Right-click on it and select "Rename" to give it a name, such as "Alphabet".
  3. Drag and drop the tabs that you want to group under the "Alphabet" tab.
  4. Repeat steps 1-3 to create additional group tabs, such as "Numbers", and move the corresponding tabs under them.
  5. To collapse a group, simply click on the arrow icon next to the group name. To expand it, click on the arrow again.

That's it! Now you have a folder structure for your tabs in the workbook, which allows you to easily organize and navigate through them.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Is there any way to create a folder structure for tabs in a workbo

You could use macros to Hide/Unhide the worksheets in groups.
--
Gary''s Student - gsnu200803


"Curious" wrote:

I work with spreadsheets with many tabs, and it would be nice if I could see
only groupings of tabs at the bottom...and then do something like double
click on a grouping to see all the tabs. Example: tabs a,b,c,...1,2,3...;
but on the bottom I would only see folder tabs "alphabet" and "numbers"...and
then I could double click on one of them to see the sub-tabs. Is this
possible?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Is there any way to create a folder structure for tabs in a workbo

Hi

No this is not possible, without writing VBA code to hide "sets" of Sheets
and unhide others.
You could label your sheets as A1, A2 ... B1 B2 etc.,
There is code available on Chip Pearson's site that will sort sheets in
alpha order for you.
http://www.cpearson.com/Excel/sortws.aspx

There are several add ins that have been written which allow you to have a
floating toolbar to enable sheet selection.
One such example would be Dave Peterson's, which can be found at.
http://www.contextures.com/xlToolbar01.html

or for XL2007 the code has been modified by Ron de Bruin
http://www.contextures.com/xlToolbar01b.html
--
Regards
Roger Govier

"Curious" wrote in message
...
I work with spreadsheets with many tabs, and it would be nice if I could
see
only groupings of tabs at the bottom...and then do something like double
click on a grouping to see all the tabs. Example: tabs a,b,c,...1,2,3...;
but on the bottom I would only see folder tabs "alphabet" and
"numbers"...and
then I could double click on one of them to see the sub-tabs. Is this
possible?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default Is there any way to create a folder structure for tabs in a workbo

Curious -

I think you would need VBA to do exactly what you want.

If I had a large number of worksheets in a workbook, I'd right-click one of
those navigation arrows at the extreme left of the worksheet tabs, bringing
up a list of the worksheets that can be selected. (This feature does not
organize the worksheets in folders, but it does give a more complete listing
of worksheets than what you can see as worksheet tabs.)

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Curious" wrote in message
...
I work with spreadsheets with many tabs, and it would be nice if I could
see
only groupings of tabs at the bottom...and then do something like double
click on a grouping to see all the tabs. Example: tabs a,b,c,...1,2,3...;
but on the bottom I would only see folder tabs "alphabet" and
"numbers"...and
then I could double click on one of them to see the sub-tabs. Is this
possible?



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
Create Directory Structure from Cell Value. [email protected] Excel Discussion (Misc queries) 0 December 3rd 07 10:02 PM
Zipping my Excel Files and maintain the folder structure Sabine Excel Discussion (Misc queries) 2 August 10th 07 06:02 PM
How do I create a dropdown list using data from a different workbo VFPguruExcelNovice Excel Worksheet Functions 4 March 6th 06 08:50 PM
can excel links be somehow relative to folder structure? Paul134 Excel Discussion (Misc queries) 0 March 2nd 06 04:22 PM
Shared folder - tabs disappear while saving gizmo Excel Worksheet Functions 0 February 3rd 05 11:36 AM


All times are GMT +1. The time now is 07:51 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"