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


B

BoB SGW

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

Advertisements

P

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...
 
P

Pravin N

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

Advertisements

W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top