If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create subworksheets within a worksheet?
I have 5 main categories (worksheets) in one workbook. Within each main
category, I have sub categories that I would like to organize in seperate worksheets. Ideally, I'd like only the 5 main worksheets to show and when one is clicked on, the subworksheets appear. Is this possible? |
#2
|
|||
|
|||
How do I create subworksheets within a worksheet?
Working from sheet set up as a "MainMenu", you could hide and unhide the
sheets so that only the ones relative to your interest appear. This would require VBA. If you are still interested post back and someone will help Vaya con Dios, Chuck, CABGx3 "Jill DeLong" wrote: I have 5 main categories (worksheets) in one workbook. Within each main category, I have sub categories that I would like to organize in seperate worksheets. Ideally, I'd like only the 5 main worksheets to show and when one is clicked on, the subworksheets appear. Is this possible? |
#3
|
|||
|
|||
How do I create subworksheets within a worksheet?
Your request is where I make use of the Outline or Grouping feature. This will place a +/- icon to the left of the rows or columns, where you can click on the + to expand the view to see the contents or click on the - to collapse the view and hide the contents. |
Thread Tools | |
Display Modes | |
|
|