PDA

View Full Version : any excel masters?


element
06-24-2004, 12:04 AM
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
06-24-2004, 12:43 AM
Go to:

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

element
06-24-2004, 12:45 AM
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!!

AirBrian
06-24-2004, 12:46 AM
Glad I could help. :)