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?