• Hey, guest user. Hope you're enjoying NeoGAF! Have you considered registering for an account? Come join us and add your take to the daily discourse.

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?
 

AirBrian

Member
Go to:

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

element

Member
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