Share via

grouping multiple sets of columns

Anonymous
2014-12-01T13:48:19+00:00

Good morning,

This is really simple I'm sure. I've done it before (or I think I have by mistake) and need to do it again.

I've got columns B through J grouped and I want to group K through T but when I try this, it just extends my original grouping.

How can I get two separate groups that follow one another?

Thanks

MM

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2014-12-01T14:06:41+00:00

    You cannot group B to J and then K to T, because you need a column in K to expand B to J

    Instead, you should group B to I, so that you can have J to expand and hide

    Then group K to S

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-12-01T17:56:53+00:00

    10-4! Thank you very much Wyman.

    MM

    0 comments