any excel masters?

Status
Not open for further replies.

element

Member
when I group something the expand icon is at the bottom of the group. I know you can change it so it is at the top, but I can't remember how to do it.

anyone know?
 
Go to:

"Data" --> "Group and Outline" --> "Settings..." --> and uncheck the "Summary rows below detail" box. That should do the trick.
 
AirBrian said:
Go to:

"Data" --> "Group and Outline" --> "Settings..." --> and uncheck the "Summary rows below detail" box. That should do the trick.
you are my all time new hero!!
 
Status
Not open for further replies.
Top Bottom