Grouping rows or columns
I will show you the two methods that can be used to add comments to cells in Excel, one involves the right-click menu and the other the Office Ribbon menu.
1. Select a set of rows or columns that you wish to group together.
2. Click on the Data tab located in the Ribbon
3. Click on the Group button located in the Outline Group
You will notice that Excel created a new margin with a set of dots next to each row, you will also notice that it created a small box with a minus sign indicating that the group is expanded. Click on the minus sign (-) to collapse the group. When you clicked on the minus sign (–), it collapsed the group and changed it to a plus sign (+).
Notice how the margin has a 1 and 2. This indicates that there is a single level grouping. If you create additional groups within the one we just created, the margin would show a 1, 2, and 3. This helps in knowing the levels of grouping in a particular sheet. You can have up to 8 levels of grouping.
By default, grouping sign goes to the bottom of selected cells, which create a wrong perception sometimes. To avoid this, you should deselect summary rows below details from the bottom right corner of outline group.
So, our grouping file is now looks like:
Ungrouping rows or columns
1. Make sure you select the groups that you wish to ungroup, do this by selecting the rows or columns that are grouped.
2. Click on the Data tab located in the Ribbon.
3. Click on the Ungroup button located in the Outline Group
You can Expand a group by clicking on the Show Detail button located in the Outline Group. You can Collapse a group by clicking on the Hide Detail button located in the Outline Group.