ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Grouping columns (https://www.excelbanter.com/excel-discussion-misc-queries/168375-grouping-columns.html)

officegirl

Grouping columns
 
AI am grouping columns a B C and than I like to group D E F but in a
separate + sign excel 2002 merges all six columns under one plus sign , how
can i separate them ?

Mike H

Grouping columns
 
Hi,

When you group columns A,B & C by default column D becomes a summary column.
To stop this click

Group|Settings and uncheck summary column to right of detail and then create
your group.

You should then be aable to create a seperate group of columns D,E & F.

Mike

"officegirl" wrote:

AI am grouping columns a B C and than I like to group D E F but in a
separate + sign excel 2002 merges all six columns under one plus sign , how
can i separate them ?


Bob Phillips

Grouping columns
 
You can't, you would need an ungrouped column between them.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"officegirl" wrote in message
...
AI am grouping columns a B C and than I like to group D E F but in a
separate + sign excel 2002 merges all six columns under one plus sign ,
how
can i separate them ?




officegirl

Grouping columns
 
Hi Mike
thanks for your answer but it does not work the way you said it it moves the
+ to the left but when I add DEF it mergers it into ABC

"Mike H" wrote:

Hi,

When you group columns A,B & C by default column D becomes a summary column.
To stop this click

Group|Settings and uncheck summary column to right of detail and then create
your group.

You should then be aable to create a seperate group of columns D,E & F.

Mike

"officegirl" wrote:

AI am grouping columns a B C and than I like to group D E F but in a
separate + sign excel 2002 merges all six columns under one plus sign , how
can i separate them ?



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com