Group and Sub Group In MS Excel
Some times we have huge data and it is not easy to control or move inside the sheets from one row to another or one column to another. We can summarize the data with the help of "Group Function". Some times it looks very difficult but if we understand we can use the "Group Function" and make our reporting easy. We can use grouping in both rows as well as columns separate.
Group:
Short Cut Key : Alt + A + G + G
Before using a short cut key you must select the range to apply the function.
Example 1 - How To Apply Group In Rows.
Let suppose we have data of school attendance and we want to create a group among the students. We can select the data and Go To Data from the menu bar and click Group.
Result: After clicking on Group Button, we can see the result in image 2. See the red arrow (Image: 2 ) one (-) minus sign is start reflecting, we can click to make the report length reduce.
Example 2 - How To Apply Group In Columns.
Image 3 is the example to create grouping in columns. The first step is to select the data range and Go To Data from the menu bar and click Group.
Result: Once we click on Group Button, the sheet will create a group among the columns and we can see the result in image 2. See the red arrow (Image: 2 ) indicating the symbol one (+ ) plus sign. (+). The sign means the data has created the group, we can click to expand or reduce the report.
By Group function we can make work easy and fast. To make a good understanding, use the same data, and follow the examples. Once we will learn the Group in excel we can also ungroup the data. If you would like to ungroup the grouped area, you can select the range and click ungroup. The data will be ungrouped and convert as a simple report.
Ungroup
Short Cut Key: Alt + A + U + U
Please comment and share if you like the post.
For more queries, you can comment.
Thanks for your time.
Group:
Short Cut Key : Alt + A + G + G
Before using a short cut key you must select the range to apply the function.
Example 1 - How To Apply Group In Rows.
Let suppose we have data of school attendance and we want to create a group among the students. We can select the data and Go To Data from the menu bar and click Group.
 |
| Image: 1 |
Result: After clicking on Group Button, we can see the result in image 2. See the red arrow (Image: 2 ) one (-) minus sign is start reflecting, we can click to make the report length reduce.
 |
| Image: 2 |
Example 2 - How To Apply Group In Columns.
Image 3 is the example to create grouping in columns. The first step is to select the data range and Go To Data from the menu bar and click Group.
 |
| Image : 3 |
Result: Once we click on Group Button, the sheet will create a group among the columns and we can see the result in image 2. See the red arrow (Image: 2 ) indicating the symbol one (+ ) plus sign. (+). The sign means the data has created the group, we can click to expand or reduce the report.
 |
| Image: 4 |
By Group function we can make work easy and fast. To make a good understanding, use the same data, and follow the examples. Once we will learn the Group in excel we can also ungroup the data. If you would like to ungroup the grouped area, you can select the range and click ungroup. The data will be ungrouped and convert as a simple report.
Ungroup
Short Cut Key: Alt + A + U + U
Please comment and share if you like the post.
For more queries, you can comment.
Thanks for your time.
Comments
Post a Comment