View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How to get plus/minus box of data group at top, not bottom of grp

There sure is...Here's how:

From the Excel main menu:
<data<group and outline<settings
Uncheck: Summary rows below detail

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JMSprout" wrote:

When you highlight rows, go to Data, then Group or Outline, then Group, it
creates a nice plus/minus expand/collapse box for that group, only when the
group is expanded the button to collapse it is at the bottom row of the
group. Is there a way to get this button located at the top row of the group?