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

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


cheers, teylyn
mikecox_Author Commented:
First answer got the point; it was simple and easy to understand.
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