Grouping

[Guest]

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

 

[RagDyer]

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.