Microsoft Office Tutorials and References
In Depth Information
Organizing Data into Levels
After you have sorted the rows in an Excel worksheet or entered the data so that it
doesn’t need to be sorted, you can have Excel calculate subtotals or totals for a portion
of the data. In a worksheet with sales data for three different product categories, for
example, you can sort the products by category, select all the cells that contain data,
and then open the Subtotal dialog box. To open the Subtotal dialog box, display the
Data tab and then, in the Outline group, click Subtotal.
In the Subtotal dialog box, you can choose the column on which to base your subtotals
(such as every change of value in the Week column), the summary calculation you want
to perform, and the column or columns with values to be summarized. After you define
your subtotals, they appear in your worksheet.