Excel 2007: How do I group rows upwards instead of downwards?

[BoB SGW]

Was fine in older versions but can't find the settings for grouping rows or
columns.

 

[Davesexcel]

That's interesting,
do stairs go up, or do they go down?

 

[Pablo Jaramillo]

Well, I just registered to answer this question. it was so frustrating to try to find out this option...

To enable the "grouping upwards" (or grouping by the first row) you have to go to the Outline section in the Data tab and click the right-down corner of the box. In that settings box that pops up, unselect the option "Summary rows below detail"... and it's DONE!!

I hope this helps somebody else to solve this "silly" issue...

 

[Pravin N]

I was facing the same issue now and this post helped me. Thanks.

 

[willy.drucker]

Was fine in older versions but can't find the settings for grouping rows or
columns.

Couldn't find the option, solved for me as well, thanks.

 

[mail.marco]

Finally!! thanks! XD