grouping columns??

[NYcowgirl]

I am using Excel 2007. I need to create several groups of columns in a spreadsheet. It allows me to group columns A, B & C. When I try to create a separate group with columns D, E & F, is adds it to the first group with A, B & C. How do I create separate groups of columns on the same spreadsheet?

 

[number kruncher]

Try a column between your 'groups' to keep them seperate.

 

[NYcowgirl]

We do not want to do that in this spreadsheet. Too many columns to begin with.

 

[number kruncher]

The seperator column can be hidden, if the screen real estate is at a premium.

 

[NYcowgirl]

still not a good option for this particular spreadsheet (for various reasons).

 

[Peter_SSs]

I am using Excel 2007. I need to create several groups of columns in a spreadsheet. It allows me to group columns A, B & C. When I try to create a separate group with columns D, E & F, is adds it to the first group with A, B & C. How do I create separate groups of columns on the same spreadsheet?

As far as I know it isn't possible. One reason is that the +/- expander/contracter symbol occupies the next column after the grouped ones. That would interefere with the next set of grouped columns if there wasn't a spare one.

The seperator column can be hidden, if the screen real estate is at a premium.

It certainly can be hidden - but with some impact on usability since you cannot then readily access the +/- symbol. Not too hard to collapse an individula group as you can click its horizontal line but once collapsed, it is difficult to expand an individual group since you then have no access to the grouping graphics at the top.

 

[number kruncher]

Working with the Flexibility and sometimes the Limitations of Excel keeps Innovation and Invention alive and well.

 

[msofficianado]

U can shrink the column width if you want to save screen space...

still not a good option for this particular spreadsheet (for various reasons).

 

[NYcowgirl]

screen space is not the problem here....

 

[peoplesoft]

Quick question on your requirement -
when you group A, B & C are you grouping them into Column D or Column C?