![]() ![]() In this example, we will use the Subtotal command with a T-shirt order form to determine how many T-shirts were ordered in each size (Small, Medium, Large, and X-Large). 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 |