Microsoft Office Tutorials and References
In Depth Information
Organizing data into levels
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 Year column), the summary calculation you want to
perform, and the column or columns that have values to be summarized. After you define
your subtotals, they appear in your worksheet.
Search JabSto ::

Custom Search