How can I make Grouping with summary rows ABOVE detail the default

  • Thread starter Thread starter M.Siler
  • Start date Start date
M

M.Siler

In Excel 2002 on the Menu: Data > Group and Outline > Settings

I'd like to make the setting "Summary rows below detail" unchecked as the
default. I have never wanted it with the summary row below the detail
therefore I have to go into this EVERYTIME I use grouping. Is there a way I
can make it unchecked as the default?
 
Is there a way I can make it
unchecked as the default?
Click to expand...

Can't say. An option would be to use code to run it (stored in personal.xls
& assigned to a custom toolbar button) ;

Application.Dialogs(xlDialogSubtotalCreate).Show , arg6:=False

HTH,
Andy
 
Back
Top