![]() Click on Outline and then click on Group toolbar. Step 2: As the user has selected a row for the month of March and the region is East. Step 1: Look at the below data in Excel Sheet, which a user wants to group and select the row/column. Click the minus sign to hide and the plus sign to show it again. ![]() Now the user can hide or show the group using the button that is attached to the bracket created on the left side. As well as two-level buttons are created on the left of the worksheet, the highest level, which is level 2, will show all the data while level 1 will hide the details of each size and leaving subtotal. Summary of Example 1: As the user selects the row for the month of March, it is grouped into one. Step 4: The pop- up Group will now show that select Rows (As the user wants to group by row).
0 Comments
Leave a Reply. |