Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Tallying columns based on values of 2 different columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Lookup Data in Several Columns | Excel Worksheet Functions |