Grouping Rows in Excel 2007
 

Hi.

I have three rows of data which I want to group with the subtotal above them.

In excel 2003 and earlier I could select the items, group them and then right
click on settings to switch off "Summary below data".

This would then put the - sign in the row above the date. A row which I had
manually added with a relevant title and subtotal.

This avoided the automatic insertion of irrelevant titles and subtotals.
I could group data without a common reference.

This manual method does not seem to be available in Excel 2007.

Am I missing something?

Grouping Rows in Excel 2007
 

On the Outline Group, which Subtotal is part of, you will see a faint arrow
in the bottom right-hand corner. Click that and it gives you the option to
switch off 'Summary below data'

--
__________________________________
HTH

Bob

"Philip J Smith" wrote in message
...
Hi.

I have three rows of data which I want to group with the subtotal above
them.

In excel 2003 and earlier I could select the items, group them and then
right
click on settings to switch off "Summary below data".

This would then put the - sign in the row above the date. A row which I
had
manually added with a relevant title and subtotal.

This avoided the automatic insertion of irrelevant titles and subtotals.
I could group data without a common reference.

This manual method does not seem to be available in Excel 2007.

Am I missing something?

Grouping Rows in Excel 2007
 

Many Thanks.

I keep forgetting those little arrows :-)

"Bob Phillips" wrote:

On the Outline Group, which Subtotal is part of, you will see a faint arrow
in the bottom right-hand corner. Click that and it gives you the option to
switch off 'Summary below data'

--
__________________________________
HTH

Bob

"Philip J Smith" wrote in message
...
Hi.

I have three rows of data which I want to group with the subtotal above
them.

In excel 2003 and earlier I could select the items, group them and then
right
click on settings to switch off "Summary below data".

This would then put the - sign in the row above the date. A row which I
had
manually added with a relevant title and subtotal.

This avoided the automatic insertion of irrelevant titles and subtotals.
I could group data without a common reference.

This manual method does not seem to be available in Excel 2007.

Am I missing something?