View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default How to get the plus/minus at the top when grouping

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.