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?