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

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?

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

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



On Jun 16, 12:15*pm, rocketboy
wrote:
InExcel2003 I use to be able to easily set whether I wanted the data group
expand button to be displayedaboveorbelowthe rows (to the left or to the
right in the case of columns) being grouped. *InExcel2007this 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?

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

finally--the answer: http://office.microsoft.com/en-us/ex...CH100648541033