![]() |
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 ? |
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 ? |
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 ? |
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