[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.

"Billy Leung" wrote:

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

[Gord Dibben]

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


Gord Dibben MS Excel MVP

On Thu, 25 Jun 2009 03:37:01 -0700, Joel
wrote:

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

"Billy Leung" wrote:

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