Forum Discussion
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
You can't use subtotals in an "Excel Table". Convert your table to a normal data range (DATA, Table tools, Convert to range). Then the subtotal option will be available again in both the DATA menu and ribbon.