Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
Can't you click on the *numbers* and get the same expand and collapse
displays? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "pspiel" wrote in message ... The problem seems to be that the summary colum is the same for both the group and the sub-group. For example, the top group is columns I through M. The sub group is columns J through M. Sometimes I want to hide I throuh L, and sometimes I want to hide J through L and leave I showing. It won't let me do that. I don't know why. "Dave Peterson" wrote: Maybe you're not changing the range when you're applying the secondary grouping. Try it with a smaller set of columns. pspiel wrote: I have a set of columns in a group. Within that set I've made a sub-group. For some reason the +/- doesn't appear for the nested group, so I can't hid just those columns. For some reason I don't have this problem with rows. With rows if I make a group within a group the +/- boxes appear for both and I can hide or unhide them with ease. But for columns the +/- box only appears in the top row. How can I make it appear for the sub-group too? -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
formula to show 97.826 as 97.825 | Excel Discussion (Misc queries) | |||
show text after formulas | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Show a date based on today | Excel Worksheet Functions |