Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping columns | Excel Discussion (Misc queries) | |||
Formatting and Grouping Columns | Excel Discussion (Misc queries) | |||
Help with grouping columns | New Users to Excel | |||
Colour Grouping of Columns | Charts and Charting in Excel | |||
Grouping Columns | Excel Discussion (Misc queries) |