Creating 2 separate but consecutive groups

Posted on 2012-09-13
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

    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

    Expert Comment


    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now