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



On Jun 16, 12:15*pm, rocketboy <rocket...@discussions.microsoft.com>
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?

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