Creating 2 separate but consecutive groups

Posted on 2012-09-13
Medium Priority
Last Modified: 2012-09-13
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?
Question by:mikecox_
LVL 17

Accepted Solution

ExcelGuide earned 2000 total points
ID: 38394013
This cannot be done. You really have to use an extra blank column (for example F), so G:I will be the next group.
LVL 50
ID: 38394058

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

Author Closing Comment

ID: 38395979
First answer got the point; it was simple and easy to understand.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question