Different Combination of Columns Appear

[Billy Leung]

Hello, assuming I have a list which contains fours columns A - D. I want to
see different column group appear in different circumstances by using group /
ungroup function (click 1, 2, 3 or 4 at the left top).

I've the following combination
1: A+B
2: A+B+C
3: A+B+D
4: A+B+C+D

I could successfully create 1, 2 and 4, but not 3. Please advise.

Regards,
Billy

 

[Joel]

Click the 1st column. Then hold down the CNTL key and click the other
columns you want to group.

 

[Gord Dibben]

Excel won't accept non-contiguous columns for grouping.


Gord Dibben MS Excel MVP