It sounds like you may have missed a step in the subtotals process. Here's a
- step-by-step guide
to help you group your subtotals:
[list=1]
1. Select the range of data that you want to add subtotals to.
2. Go to the "Data" tab in the ribbon and click on "Subtotal" in the "Outline" group.
3. In the "Subtotal" dialog box, choose the column that you want to group by in the "At each change in" dropdown menu.
4. Select the function that you want to use for the subtotals in the "Use function" dropdown menu.
5. Check the box next to the column that you want to subtotal in the "Add subtotal to" list.
6. Click "OK" to apply the subtotals.
Once you've completed these steps, you should see groups that you can expand and collapse in your worksheet. If you're still having trouble, double-check that you've selected the correct range of data and that you've chosen the right options in the "Subtotal" dialog box.