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 b...
HelloAlex Hammerstein,
Yes, you can control where the expand/collapse icon appears when grouping rows in Excel.
To have the icon appear on the top summary row, make sure to group only the sub-rows, not the summary row itself.
✅ How to Do It
- Select the sub-rows (e.g., rows 2–4).
- Go to Data > Group.
- The expand/collapse icon will appear next to the row above your selection—right next to the summary row.
🧾 Sample Dummy Data
Item | Category | Amount |
|
Apples | Fruit | 10 |
|
Bananas | Fruit | 15 |
|
Oranges | Fruit | 20 |
|
Total Fruit |
| 45 |
|
To group the fruit items with the icon on row 4 (Total Fruit):
- Select rows 1 to 3 (Apples to Oranges).
- Click Group.
- The icon will appear next to row 4, allowing you to collapse the sub-rows beneath it.
This works in Excel 365, 2016, and 2019.
Let me know if you’d like help with nested groups or formulas!
Best regards,
Olufemi