Grouping Rows in Excel 2007

[Philip J Smith]

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?

 

[Bob Phillips]

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'

 

[Philip J Smith]

Many Thanks.

I keep forgetting those little arrows