• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1051
  • Last Modified:

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?
0
mikecox_
Asked:
mikecox_
1 Solution
 
ExcelGuideConsultantCommented:
This cannot be done. You really have to use an extra blank column (for example F), so G:I will be the next group.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
mikecox_Author Commented:
First answer got the point; it was simple and easy to understand.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now