2007 Microsoft® Office System Plain & Simple

Creating Subtotals

When you’ve accumulated a mass of data, you can leave it to Excel to calculate the subtotals in your worksheets—how many boxes of crayons you sold in January, for example, or the number of different songbirds you’ve seen in your back yard. All you need to do is group the data by the items to be subtotaled and tell Excel to outline—that is, to classify and prioritize—your data, and to calculate the subtotals. You’ll need to sort the data before you tell Excel to create the subtotals.

Create the Subtotals

1. Select and sort the data by the columns for which you want to create the subtotals.

2. On the Data tab, click the Subtotal button ...