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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPmWGMlN8BnPzYoGLtm7NEY2UxH9OJ0NqZfYImdl9-cWz3J2g094fIa0B_ip3HsFsvVD80DFdjkB2dVVaTgOlnKeFwvQgmJ9WFqEUZgRMHODbbVoavzoMDQyDOtnBPB_osMZuqHHs2tWoS/s400/Picture+7.png)
- 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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgylmH_QsMh_VtswdbqID0kMZNgkcQBQ-jQs5pIIx7dx9uq0deVUiVN45y74mSifqbS4rLZhdZ3iBKrePRU6xPc9gGDXz4RoVw8YT3cJFJWFSdqxPp0d3gWC_sKBDBwi6X8xJ_dTecAkcUc/s400/Picture+11.png)
- Click on that
- The dialogue box should pop up
- Now, uncheck the top checkbox which says, "Summary rows below detail"
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZBwdJDnll1ipqEA4xonwcMbejN_7wiy1cCJRqdLN7LKqJYl0eyYGJpOxH-PRuJITnX_iUBGW2BcWaLYF1zcQkFNBNyFHzMT0U1M5_xPIz2M2mR-HdKixtGvAv9iSNGChgx1Ow1xf_lvlY/s400/Picture+10.png)
- Click OK
- Enjoy easy and intuitive grouping and outlining!
No comments:
Post a Comment