Thus, you have added the group for one season. And then in the pop-up window, choose the option “Rows”.Then choose the option “Group…” in the menu.Click the arrow under the button “Group”.And here we select the first three month and the corresponding sales volume. Select the area that you want to add group.And in this example, we check the option. Besides, if the subtotal line locates over the details, you need to uncheck this option. In the “Settings” window, check the option “Summary rows below detail”.Click the small arrow to open the outline settings.On the other hand, you can also add groups manually. Thus, you can click the buttons on the left to hide or show the details. In the drop-down menu, choose the option “Auto Outline”.Īnd then you will find that the outline will appear in the worksheet.And then click the small arrow under the button “Groups”. And if the information has the similar attributes, you can add groups quickly. The groups feature is very smart in Excel. In this image below, there are the sales volumes of the product of each month and the subtotal of each season.Īnd for such a worksheet, you can add groups into the worksheet. And with groups, you can manage your Excel better. In Excel, you can also add groups to your information. Thus, you can add groups to classify your data and information. In an Excel worksheet, if you have a lot of data and information, the interface will be in a mess.
0 Comments
Leave a Reply. |