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?

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.

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?

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?

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?