How do I change the Data Grouping options in Excel 2007?

  • Thread starter Thread starter rocketboy
  • Start date Start date
R

rocketboy

In Excel 2003 I use to be able to easily set whether I wanted the data group
expand button to be displayed above or below the rows (to the left or to the
right in the case of columns) being grouped. In Excel 2007 this option seems
to have been eliminated and the default is the opposite of what I have always
found useful. How can I permanently, or at least for each workbook, set this
option?
 
I'm surprised this hasn't come up yet--I'm looking for the same
answer. Tried workarounds using VBA, but no luck.

Wow--office 2007 is such a giant step backward from 2003.

Sandheep
 
Back
Top