Grouping Rows - Want Top Row to Show

[sfarkas2006]

I want to use the group and outline functionality to group sets of
rows, but instead of the bottom row of the group showing when I
collapse the group, I want the top row to show. This is because each
of the items below the top row are the elements of the group and the
top row is the header.

Can this be done with the Excel grouping functionality?

Thanks.

 

[Dave Peterson]

Data|Group and Outline|Settings
Uncheck that Summary Rows below detail

 

[sfarkas2006]

Data|Group and Outline|Settings
Uncheck that Summary Rows below detail

Thanks Dave!