![]() Note: Your data must be correctly sorted before using the Subtotal command, so you may want to review our lesson on Sorting Data to learn more. ![]() It will create a hierarchy of groups, known as an outline, to help organize your worksheet. For example, the Subtotal command could help to calculate the cost of office supplies by type from a large inventory order. The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data. To show a hidden group, click the Show Detail button (+) To hide a group, click the Hide Detail button (-).Note: To ungroup data, select the grouped rows or columns, then click the Ungroup command. In our example, columns A, B, and C are grouped together. The selected rows or columns will be grouped.Select the Data tab on the Ribbon, then click the Group command.Select the rows or columns you want to group. ![]() Ever wonders how can you edit PDF in Word? Here is how: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |