Group and UnGroup in Excel to visualize data

preview_player
Показать описание
This video demonstrates, how to use Group and UnGroup features in Excel to visualize data in effective way.
  1. Excel Destination
  2. Group and UnGroup
  3. Group
  4. UnGroup
  5. Group rows in excel
  6. Group Columns
Рекомендации по теме
Excel Grouping and 0:02:00

Excel Grouping and Ungrouping

Grouping Rows and 0:05:47

Grouping Rows and Columns in Excel

How to Group/Ungroup 0:03:29

How to Group/Ungroup Rows and Columns in Excel

Group and UnGroup 0:04:17

Group and UnGroup in Excel to visualize data

Group and Outline 0:04:32

Group and Outline and Subtotal in Excel

How to Group 0:03:01

How to Group and Ungroup Worksheets in Excel

MS Excel - 0:04:45

MS Excel - Pivot Table Grouping

How To Group 0:07:44

How To Group and Ungroup Rows and Columns in Excel | Group and Ungroup in Excel | #excelcourse

Excel Group & 0:06:45

Excel Group & Outline Buttons | Easiest way to Hide & Unhide Rows & Columns

HOW TO USE 0:07:42

HOW TO USE DATA VALIDATION, FILTERS, GROUP, UNGROUP IN EXCEL

Group & Ungroup 0:03:34

Group & Ungroup Worksheets in Excel

Excel grouping shortcut 0:00:21

Excel grouping shortcut to group rows

Group and Ungroup 0:05:52

Group and Ungroup Data in Excel

How to group 0:01:19

How to group and ungroup rows and columns in Microsoft Excel 2013

Microsoft Excel - 0:02:12

Microsoft Excel - Keyboard Shortcuts to Group or Ungroup Rows and Columns

How to Group 0:08:52

How to Group and Ungroup Rows and Columns in Excel | Grouping Rows and Columns in Excel - 127

How to Use 0:05:06

How to Use Excel Group Ungroup Subtotal in Hindi - MIS tutorial

How to Group 0:03:39

How to Group and Ungroup Worksheets in Excel | changes made in multiple sheets | grouping worksheets

How To Hide-Unhide 0:03:15

How To Hide-Unhide Columns Or Rows With Plus-Minus Sign or Group-ungroup feature In Excel

How to Group 0:01:35

How to Group and Ungroup Columns in Excel

How to use 0:05:39

How to use Group & Ungroup options in Excel 2019? group/ungroup options kaise upyog karen? (Hind...

How Do I 0:01:27

How Do I Group Worksheets in Excel

Group Items in 0:05:18

Group Items in a Pivot Table

How to Group 0:01:38

How to Group Worksheets in Excel

Комментарии
Автор

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 ?

AamerAli
Автор

Thank you for this excellent video and explanation on Grouping! I will look for more of your videos.

spottedeel
Автор

Please advise if there is a way to hide the numbers which appear while grouping, from the sheet

awwashub
Автор

how do you group rows based on certain cell values automatically. excel sheet is data refreshed and every time the row value changes which disturbs the groupings. how to fix this

TheMozncat
Автор

what should i do ? my excel say" you can not group that selection" please help me

mycamquach