Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to heirarchically group worksheets, or browse them differently?
It appears to me that the only interface to choosing which worksheet
you want to see in a workbook with multiple worksheets is to select the worksheet's tab on the workbooks' bottom. I have a workbook with lots of worksheets, most of which break down logically into three or four categories. Is there a different way I can navigate to the worksheet I want? i.e., I'd like to have four categories at the bottom and then when you click on the category, you get the individual worksheets, etc. Right now I just have a long set of tabs. I imagine there's some way to do this with macros or controls - have the first sheet be a link to others or something. Just wondering if there's anything built-in that I could use. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to heirarchically group worksheets, or browse them differently?
There's nothing built-in. A macro to hide/display a static group of
sheets based on selecting another sheet (or a control) wouldn't be particularly difficult. Making the "hierarchy" customizable on the fly is slightly more challenging, depending on how much customization you want to allow. In article .com, wrote: Just wondering if there's anything built-in that I could use. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to heirarchically group worksheets, or browse them differently?
It appears to me that the only interface to choosing which worksheet
you want to see in a workbook with multiple worksheets is to select the worksheet's tab on the workbooks' bottom. I have a workbook with lots of worksheets, most of which break down logically into three or four categories. Is there a different way I can navigate to the worksheet I want? i.e., I'd like to have four categories at the bottom and then when you click on the category, you get the individual worksheets, etc. Right now I just have a long set of tabs. One simple way is to use hyperlinks. First, imagine a "table of contents" worksheet that has hyperlinks to several other sheets. Clicking on a hyperlink sends you to the sheet of interest. Then, imagine several "table of contents" sheets arranged hierarchically to let you navigate from a main sheet to one of several categories, where each category has hyperlinks to data sheets. Many variations are possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate cell row and column | Excel Discussion (Misc queries) | |||
How do i group worksheets inside a workbook into subgroups? | Excel Worksheet Functions | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |