Grouping Columns
 

Using Excel 2000 in a Win 2000 O/S, is is possible to group columns
individually? Currently if I group, for example, column C, so that I can
collapse it, when I group column D, it gets joined to column C's group. I
want to be able to collapse and expand columsn separately.
--
LPS

Maybe you could insert a very skinny column between C and D (not hidden,
though).

LPS wrote:

Using Excel 2000 in a Win 2000 O/S, is is possible to group columns
individually? Currently if I group, for example, column C, so that I can
collapse it, when I group column D, it gets joined to column C's group. I
want to be able to collapse and expand columsn separately.
--
LPS

--

Dave Peterson

It sounds like you ar using the Grouping feature differently tha it's
intended purpose -- that of Grouping 2 or more columns/rows so the group can
be collapsed (to not show detail, for example).

If you are only concerned with 1 row/column at a time, use
FormatColumnHide instead. |:)

"LPS" wrote:

Using Excel 2000 in a Win 2000 O/S, is is possible to group columns
individually? Currently if I group, for example, column C, so that I can
collapse it, when I group column D, it gets joined to column C's group. I
want to be able to collapse and expand columsn separately.
--
LPS