When I use the group and outline feature, I like to (almost always) set the group brackets to have a top-down orientation versus the bottom-up default. In other words, I like to set the group and outline feature so that when I click to expand, the rows release downwards.
To do that, take the following steps:
- Click on the Data ribbon so that you see Get External Data, Connections, etc.
- Mouse over to the Outline section of the Data ribbon
- At the bottom right corner of the Outline section, you will see a mini arrow
- Click on that
- The dialogue box should pop up
- Now, uncheck the top checkbox which says, "Summary rows below detail"
- Click OK
- Enjoy easy and intuitive grouping and outlining!
