Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with some "basic" data in rows and some "detail" data
in other rows. These two types of rows are intermixed throughout the spreadsheet. I'd like to provide this data to others and include the ability to easily hide and unhide the rows containing the "detail" data. What's the best way to do that? I have tried creating two views, two macros that point to those views, and two buttons that point to those macros. That works except that I don't see a way to modify the views as I add more data to the spreadsheet, and therefore it appears that I have to recreate the views and macros everytime. There must be a better way. Any ideas? Thanks, Chris Sites |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide/Show details in an Outline Group | Excel Discussion (Misc queries) | |||
SUBTOTAL'S SHOW AND HIDE DETAILS BUTTON MISSING | Excel Discussion (Misc queries) | |||
hide/unhide | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Hide details | Excel Programming |