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

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?
 
A

Andy Brown

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
 

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

Similar Threads

macro to show / hide grouping, linked to label button 3
copy detail to summary row in outline 1
sorting detail rows - summary row in an outline 1
grouping rows 1
Grouping Rows in Excel 2007 2
Group And outline Settings in 2007 - Grouping detail below, based onthe Cell Above 2
Getting Text data using the Data - Subtotal feature 1
groups detail section totals access 2003 3

Top