Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Grouping
Hi all, TIA, wondering when grouping if there's any way to maintain
seperation in two different sets of groups that are right after another. So, ie: Q1 123.32 324.12 543.23 Q2 654.34 765.45 123.54 If you highlight Q1 and relavent data, group it, then highlight Q2 and data, group it, Excel groups it all together, any way to keep these seperate without adding an empty row? Thanks, Kevin M |
#2
|
|||
|
|||
No, XL demands a "title" (summary, total) row or column between groups.
I don't understand why you would want to include your Q1 and Q2 rows in the group anyway. When you collapse the group, you have *nothing* visible. If you just grouped the numbers under Q1 and Q2, those "title" rows would remain visible, and you would know where to expand to see the individual data groups. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kevin M" wrote in message ... Hi all, TIA, wondering when grouping if there's any way to maintain seperation in two different sets of groups that are right after another. So, ie: Q1 123.32 324.12 543.23 Q2 654.34 765.45 123.54 If you highlight Q1 and relavent data, group it, then highlight Q2 and data, group it, Excel groups it all together, any way to keep these seperate without adding an empty row? Thanks, Kevin M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to unprotect Grouping controls | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Protect sheet and allow grouping of columns | Excel Worksheet Functions | |||
Grouping Dates in Pivot tables | Excel Discussion (Misc queries) | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) |