Excel: Groups and Subtotals

In this video, you’ll learn the basics of using groups and subtotals in Excel 2019, Excel 2016, and Office 365. Visit edu.gcfglobal.org/en/excel/gr... for our text-based lesson.
This video includes information on:
• Adding and editing headers, which appear in the top margin
• Adding and editing footers, which appear in the bottom margin
• Adding and editing page numbers to a document
• Restarting page numbering
We hope you enjoy!

[@janicefranklin8225]

Excellent and to the point. I definitely plan on using this feature on data in the future. Thank you!

[@jendotcohen]

Outstanding video! I conduct web-based learning for a living, and I think your delivery and pace are superb. The content was relevant and uncluttered. Well done!

[@bethlectic7532]

Thanks for making these videos, they are very helpful!

[@pauls7056]

Excellent. So clearly explained you made it an effortless task. Thanks.

[@jmvm711]

Really helpful. thank you !

[@murshed861]

Very good tutorial for Excel Grouping and Subtotals. Thanks.

[@mimosaa8829]

Thank you

[@westfield90]

Superb

[@floydjaywinters8409]

Excellent video! I have my own YouYube channel tutorials. And you did a much better job than I did. Congrats.

[@TriPletSTripplE]

i want formula for adding the column figures and substracting the rows figure and the total must be same .

[@GCFLearnFree]

You can review our video on creating complex formulas here for help: th-cam.com/video/J-W3thqtDpQ/w-d-xo.html&index=13.

[@nileshpawar1639]

I have a doubt regarding SUBTOTAL function. I have a data in which four columns are there namely Year (contains 2013, 2014, 2015, 2016), Region (Contains East, West, North, South), Shoe size (Contains 6, 7, 8, 9, 10) and Sales (In dollars).
I have used SUBTOTAL function to see the Year wise sales or Year wise Shoe size count. But I wanted to calculate Year wise count of Shoe sizes separately for each size. I hope you got my query. How to do this?

[@GCFLearnFree]

A custom sort will probably work better for you in this case: www.gcflearnfree.org/excel2016/sorting-data/2/. It would sort first by year and then by size. Then if you create subtotals based on shoe size, it will calculate each size individually. For situations like this, you might also want to consider using a PivotTable: th-cam.com/video/N4K3xjM76kI/w-d-xo.html. We hope this helps you!

[@nileshpawar1639]

Yes. It worked with pivot table concept. Thank you so much.

[@AamerAli]

thanks for the Video, but I have an issue with the Third level Group. if I highlight the 3rd level for grouping it is not working as I need. I cannot explain it here but the idea is like this :
(A)in row then (ABCD 123) in Row, then (A.1-A1B1C1 123) in Row, then A.1.1-A12B12C12) in Row
(B) in Row then (ABCD 456) in Row, then (B.1-B1B1C1 456) in Row, then B.1.1-B12B12C12) in Row
(C) in Row then (ABCD 789) in Row, then (C.1-C1B1C1 789) in Row, then C.1.1-C12B12C12) in Row
I need A and B and C to appear First in group.
then (ABCD 123) and (ABCD 456) and (ABCD 789) in another Group.
then (A.1-A1B1C1 123) then (B.1-B1B1C1 456) then (C.1-C1B1C1 789) in another group.
How ?

[@GCFLearnFree]

We’re not sure if we understand exactly what’s happening, but if you’re using the Subtotals feature it sometimes helps to remove the subtotals and re-add them. From the Data tab, click Subtotal, then click Remove All. Then, you can go back to the Subtotal command to create new subtotals. It’s possible that this may resolve the issue. Hope this helps!

[@twolanguagesjourney6353]

WHY the "subtotal" button is NOT active with me ??? Please help

[@GCFLearnFree]

Check our text-based lesson for help with subtotals: edu.gcfglobal.org/en/excel/groups-and-subtotals/1/

[@boorayin2773]

I'm getting my subtotals correctly, but it's not grouping them so that I can collapse/expand - ??

[@jimburford4535]

did not say your grouped data to start