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,
<Data> <Group & Outline> <Settings>
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
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Holding the Crtl key brings up the message:
"The command can't be performed with multiple sections
Select a single range and click the command again"
I'm using the Professional 2003 edition. Do you know of any other ways at
all?
Thanks