How to get the plus/minus at the top when grouping
Thanks for the reply JE.
How do you get to: data/group and outline/settings? I couldn't find it when
i went to the circle (top left) Excel Options. Nor is there a setting
option in the Outling group of the ribbon.
Thanks,
Beac
"JE McGimpsey" wrote:
One way:
Choose Data/Group and Outline/Settings...
Uncheck the "Summary rows below detail" checkbox.
In article ,
beac wrote:
Hello,
I am grouping several rows in excel 2007 but want the plus/minus control to
be at the top of the group rather than the bottom. I am unable to figure
this out from within excel. When I export a report from SQL Server Reporting
Services to excel that has drill down, the plus/minus control is at the top
of the grouping.
Thanks for the help.
|