Home

Help with Subtotals

%3CLINGO-SUB%20id%3D%22lingo-sub-1013365%22%20slang%3D%22en-US%22%3EHelp%20with%20Subtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013365%22%20slang%3D%22en-US%22%3EI%20am%20in%20the%20process%20of%20doing%20my%20project%20for%20school%20and%20I%20can%20not%20do%20the%20step%20that%20involves%20using%20subtotals%20in%20my%20excel%20table%20as%20it%E2%80%99s%20grayed%20out..%20any%20help%20would%20be%20greatly%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1013365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1013575%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Subtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459795%22%20target%3D%22_blank%22%3E%40SacStone94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can't%20use%20subtotals%20in%20an%20%22Excel%20Table%22.%20Convert%20your%20table%20to%20a%20normal%20data%20range%20(DATA%2C%20Table%20tools%2C%20Convert%20to%20range).%20Then%20the%20subtotal%20option%20will%20be%20available%20again%20in%20both%20the%20DATA%20menu%20and%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1013456%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Subtotals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013456%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3ETo%20use%20the%20subtotal%3CBR%20%2F%3E1.%20Sort%20the%20data%20to%20subtotal%3CBR%20%2F%3E2.%20In%20the%20Outline%20group%20of%20the%20Data%20tab%2C%20click%20on%20Subtotal%3CBR%20%2F%3E3.%20In%20the%20Subtotal%20box%2C%20click%20the%20At%20each%20change%20in%20dropdown%20and%20select%20the%20column%20to%20subtotal%20on%3CBR%20%2F%3E4.%20Select%20the%20function%20from%20the%20use%20function%20dropdown%3CBR%20%2F%3E5.%20In%20the%20Add%20subtotal%20to%20dropdown%2C%20check%20the%20box%20where%20you%20want%20the%20subtotal%20to%20appear%3CBR%20%2F%3E6.%20Click%20OK.%3CBR%20%2F%3ENote%2C%20Subtotal%20doesn't%20work%20when%20data%20is%20stored%20in%20Excel%20Table.%3CBR%20%2F%3EKindly%20let%20me%20know%20if%20this%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ERegard%3C%2FLINGO-BODY%3E
Highlighted
SacStone94
Occasional Visitor
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
2 Replies
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

@SacStone94 

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies