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. |