Select two columns from Mineral water by Ctrl + Click or Shift + Click.
From the Insert tab, under the Customize section, select Group or use the shortcut key Alt + W.
Fig1. Group
Group two or more relevant columns/rows in the same hierarchy level to create another category.
This section will cover how to create:
Let’s consider the example of grouping products into 2 categories:
Select two columns from Mineral water by Ctrl + Click or Shift + Click.
From the Insert tab, under the Customize section, select Group or use the shortcut key Alt + W.
Fig1. Group
Give an appropriate name for the group in the dialogue box that appears and click Apply.
Fig2. Create Group Name
Fig3. Group two columns
To remove the group, select the group name header and click on Remove Group from the Analyze section in the Insert Tab.
Fig4. Remove Group
Fig5. Column Group removed
You can group one or more consecutive rows in the same hierarchy level.
Let’s consider an example of creating a group for the regions under the United States:
Select the required rows by Ctrl + Click or Shift + Click.
From the Insert tab, click on Group from the Analyze section or use the shortcut key Alt + W.
Enter the name for the group in the “Create Group” dialog box that appears and click Apply.
Fig6.Select Rows to group
Fig7. Row Group Sample 2 inserted
To remove the group, select the group name and click on “Remove Group” from the Insert Tab.
Fig8. Remove Group
Fig 9. Row Group removed