Excel Grouping (Rows and Columns) | How to Group in Excel

Have you ever wanted to know how to make sense of complicated Excel data? In this video, I'm going to show you the power of Excel's grouping function and how it can be used to make your data easier to read and understand at a glance.

00:00 Introduction to MS Excel Grouping
00:10 How to Group in Excel
01:15 How to Ungroup in Excel
02:02 How to Group Row's in Excel
02:28 Excel Grouping Bonus Trick 1
02:38 Excel Grouping Bonus Trick 2

Excel Grouping (Rows and Columns) | How to Group in Excel
#ExcelGroup #excelungroup #excelgrouping

If a year's sales data is broken down in quarterly format, and you do not want to show the details each time. You can add a button that will hide and unhide the quarterly columns.

Let's Connect:

[kirtipriyamvadatangirala]

thank you sir for a short and informative video.

[jaquanamiles]

Thank you. Great demo! Once you group columns or rows, do you know if it's possible to give a title/label to the grouping? I want to be able to quickly identify what's in the grouped rows/columns without expanding them. Thanks.

[yurnisanisa]

Thank you so much! It helped a lot! Currently I have a long list of things and needed this for ease of going through the excel x)

[Unknown-rkqm]

How can I group every Quarter individually? So that every column has its own "Minimize" and "Maximize" button?

[waiswamusa]

This has been very helpful. Thanks much

[jalilbazyar]

Well and Easley explained. Thank you!

[tulor]

Great video! I click group and nothing happens. The boxes with numbers at the top of the screen don't appear...

[parminderghai]

Hi, can we group random rows or columns which are not consecutive to each other ?

[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 ?

[kinjaldoshi]

Please solve the following my query

One sheet : Name And Pancard
Other sheet:duplicate name and pancard
Result: Insert PAN number and get details all reated that PAN number (not sorting)

[learnenglishwords]

Sir how to do entry in same if say ram is playing 2 games, Ram Game 1, Game 2.
Now ram joined new I wanted sir, that I should not do new entry of Ram n his game,
I wanted sir, Ram name should be searches and entry should come to empty cell in same row and Game 3 should add in the row of Ram.