How do i make a tree structure?

[jimmie james]

when i open a new file in excel i get sheet1 sheet2 and sheet3.
is there a way to have to each sheet a subsheet( and to that
subsubsheet) for example if i will go to sheet1 i will have agai
sheet1b sheet2b sheet3b and so on?
is it possible to see them vertically, and not horizontally , so i wil
get some sort of tree structure to navigate through the different sheet
and subsheet (like you have when you explor your computer). ?


Thanks in advance
Jimmie Jame

 

[Harald Staff]

Hi Jimmie

I don't think Excel has anything built-in that does this.
The idea is fantastic though. Someone should program it as an Excel addin.
The downside of "the easy Visual Basic way" is the need of an accessible
tree component installed on all users' systems.

HTH. Best wishes Harald

 

[Earl Kiosterud]

Jimmie,

Indeed -- Excel has all the sheets in one level - the workbook level.

One possibility is to use hyperlinks in each first-level sheet to all of its
second level sheets, and on. Each would have a hyperlink back to its
parent. The user would just click a link to go to a sheet. The actual
sheets would just be in the one available level of the workbook, and could
be in any physical order. Changing the organization would involve
rebuilding a lot of hyperlinks.

Or you could make a menu sheet of just the hyperlinks, organized with the
hierarchical structure you need (like the outline structure you mentioned
that Windows uses, or a tree structure, though that can get unwieldy). Each
actual sheet could have a hyperlinklink back to this menu. Using the
outline structure, you'd probably use a one-row-per sheet arrangement,
indenting (a column over) to indicate the child relationships, and it could
include comments and other fields in other columns. Dragging and dropping
the rows could change the hierarchy (though you'd need to drag any
child-level sheets with the parent). The Shift key is handy as you drag for
that kind of reorganization.

You could even use two windows (Window - New window) and have the menu at
the left (to keep it visible), and a selected sheet at the right. A the
maximize button, or a button-fired macro could switch to all menu, or all
worksheet.

Just some thoughts. I haven't really thought this all the way through, so
there might be an onslaught in this thread!