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

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

Similar Threads

Sharing Access MDB or Accdb with client using older or newer version of Office 1
Cell data entering slow! 0
Documents Not Appearing (as it used to) On Desktop ? [on a Mac] 0
Need some PWA help 0
Sharing Excel 365 Mac<->PC 0
How to filter rows data based on background color of individual cells 3
Export BPMN Visio Chart to Excel 0
Integrating information from Word to Excel (not mail merge) 1

Top