Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping (Office 97)

    If I want to group together (from the Data/Group and Outline) for example the columns A-F and in a separate grouping the G-T, I can't because the whole thing gets grouped together. Is there a way to group them separately though? I don't want to have an empty column between the two groupings, and right now this seems to be the only way to get the effect I desire.

    Thanks,
    K.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping (Office 97)

    Works for me, as long as I group them one at the time:

    - select first set of columns, data, group and outline, group
    - select second set of columns, data, group and outline, group

    I can then expand both at will.

    Or is that not what you meant?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping (Office 97)

    That's what I want as well, but as soon as I group the second set of columns, they will get grouped together with the first one, as it was all one single group.
    Could you possibly post a small xls file to show the result of what you got?
    Thx,
    K.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping (Office 97)

    Here it is...
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping (Office 97)

    Thanks, it works now.

    K.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •