Excel Group Rows and Sum Automatically - 3 methods (2020)

How to group rows in Excel? That's what you will learn in this tutorial! I'll show you three ways on how to group rows and two of them are actually automatic functions in Excel. With the last method you will also be able to automatically calculate the sum of your grouped columns/rows. So, basically we are talking about the automatic calculation of the subtotal values.
By the way: after you grouped the rows, you will also be able to expand and collapse them. So, if you wondered how to collapse rows in Excel, you first have to group them.

This tutorial for #group #rows in Excel should work for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 and also Office 365. This also works with Microsoft Office on a Mac and also with open source software such as OpenOffice or Libre Office.

#leonrenner

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
💗 I need your support. Yes, YOU can help me (if you want it).

If I helped you, I would really appreciate it if you subscribe to my channel, leave a comment 📝 and hit the like button 👍

[LeonRenner]

If you wanna spread some 💗 please smash the 👍 button, so I can make more videos like this in the future. Thank you! 💗💗

[comptegmail]

sir can I keep the subtotal row only and remove the other rows? because the total no long shows if I remove

[codeU-yi]

thanks, BUT HOW DO I PLACE THE TITLE FOR EACH GROUP AUTOMATICALLY, A the start of the group instead of at the end?

[makadiyavaibhav]

what if the months are jumbled will it work? for ex: june june june july july june aug aug aug

[adrian_]

how can i put the title of the group ABOVE, when the group is opened? it's so annoying to have it at the end of the group

[simpitacademy]

I don't see the subtotal icon in Data