How to get the plus/minus at the top when grouping

B

beac

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.
 
J

JE McGimpsey

One way:

Choose Data/Group and Outline/Settings...

Uncheck the "Summary rows below detail" checkbox.
 
B

beac

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
 
J

JE McGimpsey

Whoops, missed the XL07. Don't have a copy handy right now. I'd say
search Help, but I don't know that it would do any good...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top