Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Why Cant I Add Subtotals In Excel Table. Subtotals are not supported in Excel tables. To add subtotals convert your table to a range of data by right-clicking a cell in your table pointing to Table and then clicking Convert to Range.
The Subtotal dialog box always wants to subtotal by the leftmost column. So make sure you uncheck that box. The Subtotal command will appear grayed out if you are working with an Excel table.
If we use that menu to enable subtotals then check Field Settings for Category subtotals are again set to Automatic.
Then rename a group or add more items. Sounds as if your data is in a table. In Excel 2003 youll find Subtotals on the Data menu. In Excel 2007 and 2010 Subtotal why Microsoft removed the s in later versions is a mystery is in the Outline group on the Data tab.