Forum Discussion
SacStone94
Nov 16, 2019Copper Contributor
Help with Subtotals
I am in the process of doing my project for school and I can not do the step that involves using subtotals in my excel table as it’s grayed out.. any help would be greatly appreciated
Abiola1
Nov 16, 2019MVP
Hello,
To use the subtotal
1. Sort the data to subtotal
2. In the Outline group of the Data tab, click on Subtotal
3. In the Subtotal box, click the At each change in dropdown and select the column to subtotal on
4. Select the function from the use function dropdown
5. In the Add subtotal to dropdown, check the box where you want the subtotal to appear
6. Click OK.
Note, Subtotal doesn't work when data is stored in Excel Table.
Kindly let me know if this help.
Regard
To use the subtotal
1. Sort the data to subtotal
2. In the Outline group of the Data tab, click on Subtotal
3. In the Subtotal box, click the At each change in dropdown and select the column to subtotal on
4. Select the function from the use function dropdown
5. In the Add subtotal to dropdown, check the box where you want the subtotal to appear
6. Click OK.
Note, Subtotal doesn't work when data is stored in Excel Table.
Kindly let me know if this help.
Regard