Creating 2 separate but consecutive groups
If I select col C:E and click "Group" those three columns become a group.
If I then select col F:H and click "Group" the previous group C:E is simply extended, and becomes one large group C:H!
How do I create two separate groups C:E and F:H?
If I then select col F:H and click "Group" the previous group C:E is simply extended, and becomes one large group C:H!
How do I create two separate groups C:E and F:H?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
First answer got the point; it was simple and easy to understand.
the grouping functionality assumes that there will be a row (or column) between the groups to total the preceding data. You cannot arbitrarily select adjacent blocks of data and group them. You will need a separator row or column for that. For details see
http://office.microsoft.com/en-us/excel-help/outline-group-data-in-a-worksheet-HA010095247.aspx
cheers, teylyn