Forum Discussion
Grouping Data
Hello. I have grouped some rows together, consisting of a top row, with a number of sub rows. The top row is the sum of the sub-rows. At present the icon to expand /close the sub rows is at the bottom. Is there anyway to have this icon at the top row?
Many thanks
1 Reply
Take this for moving the Grouping Icon to the Top Row
1. Select the grouped rows.
2. Go to the Data tab on the Ribbon.
3. Click the small arrow in the bottom-right corner of the Outline group to open the Settings dialog.
4. In the Settings window, uncheck "Summary rows below detail".
5. Click OK.
