Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Collapsing Rows
I have seen spreadsheets where rows are subtotaled and the rows making up the
subtotaled are hidden. In other words, rows are expanded and then the detail is closed. My question is how do I set up my spread sheet to expand and collapse? I would appreciate any help. -- ERSCPA |
#2
|
|||
|
|||
Sort your data by some key column.
Then select your range and do Data|subtotals Use at each change in that key column to count/sum/average.... for every field you want. You'll see those outlining symbols to the left. You can expand/hide by clicking on those numbers at the top or by clicking on the +/-'s for each level. ===== You can also get them via data|Group. EdCPA wrote: I have seen spreadsheets where rows are subtotaled and the rows making up the subtotaled are hidden. In other words, rows are expanded and then the detail is closed. My question is how do I set up my spread sheet to expand and collapse? I would appreciate any help. -- ERSCPA -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave, I was looking for this solution. -- IndianGuru ------------------------------------------------------------------------ IndianGuru's Profile: http://www.excelforum.com/member.php...o&userid=27382 View this thread: http://www.excelforum.com/showthread...hreadid=469732 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Expanding and collapsing rows | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |