Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2006

Tip: Looking for answers? Try searching our database.

Tree View of spreadsheet tabs: is it possible?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scooterm@hotmail.com - 01 Jun 2006 18:07 GMT
PROBLEM:
Suppose I have a workbook with the following sheets:

USA-north
USA-south
USA-east
USA-west
USA-west-region1
USA-west-region2

CAN-north
CAN-south

QUESTION:
Is there any way to display a "collapsable tree view" of the sheets?
(in a side panel that occupies the entire left side of the GUI, similar
to what you would see in msft windows "explorer tree view"). It would
be nice to have a view where the topmost 'nodes' of the tree would be
USA and CAN which are collapsable and expandable to reveal and
hide the various child nodes associated with them.

RATIONALE:
The reason for this request is that this option (if available) would
help
to visualize the data in the sheets more easily as well as avoid the
effect
of 'runaway spreadsheet tabs' that scroll off the side of the screen at
the
bottom. In other words, a collapsable "show/hide" tree view would make
it easier to navigate the various subgroups of spreadsheet tabs.

Absent availability of this feature, is there an alternative approach
anyone
has found, assuming I am not the first person in the world to think of
this
idea?
Daniel CHEN - 01 Jun 2006 21:47 GMT
Most likely is is not possible w/o coding.
Here is a utility program which does the following:
1) Sort all the sheets in order
2) Create a summary sheet listing all sheets' names
3) Links to each individual sheet.

Download at: http://www.xldatasoft.com/downloads/SortSheet.xls
This may not what you want, but it helps you to visualize the organization
of your sheets.
Hope this helps.

Signature

Best regards,
      ---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Tool & Training Material for Download
==================================

> PROBLEM:
> Suppose I have a workbook with the following sheets:
[quoted text clipped - 32 lines]
> this
> idea?
Dave Peterson - 01 Jun 2006 22:26 GMT
Another option from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

> PROBLEM:
> Suppose I have a workbook with the following sheets:
[quoted text clipped - 32 lines]
> this
> idea?

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.