In excel sheet, sometimes we want to group column B-C-D into one group and
E-F-I into another group. But the result is column B-C-D-E-F-I is merged
into one group, so we have to insert unnecessary column between D & E, do we
have the way to fix this.

thank you so much,
suwat u. (Thailand)

Please read the reply frm RagDyer below, It explains why there is a need for a column between the groups.
Grouping Multiple Side by Side Columns - RagDyeR
14-Jan-09 12:21:11

Copied from an old post:

If you read about this feature in the Help files, one of it's main precepts
is the *necessity* to *always* have a totaling or title row (column)
*between* groups.

Select rows 1, 2, and 3, and group them.
Select 5, 6, and 7, and group them.


You see the outline symbols ( - ) at row 4 and row 8.


Click on them to compress the groups (rows).


Row 4 and 8 have to be visible as labels (totals) for the groups,
so you can click on them to expand the group(s).


NOW, select rows 10, 11, and 12, and group them.
Then, select rows 13, 14, and 15, and group them.


You see what XL does!


It combines the groups into a *single* group, and makes row 16 the title
row.


If you don't have or need these intervening rows as part of your data, just
use empty rows where you can minimize them.
If you hide them, you hide the controlling outline symbols for that group.


Also, the default setting for these title (summary / total) rows is to be
beneath the detail rows.
You can change that if you wish.
From the Menu Bar,
And make your choices from the dialog box.


*Don't* change it to TOP, and then decide to group rows 1, 2, and 3.
You'll never see the outline symbol.<bg


We've been talking about single level grouping here.


It's exactly the same rules for multi-levels, you need that row (column) in
between


--
HTH,


RD


"Suwat Upathambhakul (Thailand)" . com wrote in message ...
In excel sheet, sometimes we want to group column B-C-D into one group and
E-F-I into another group. But the result is column B-C-D-E-F-I is merged
into one group, so we have to insert unnecessary column between D & E, do we
have the way to fix this.

thank you so much,
suwat u. (Thailand)