Organizing Data into Levels
After you have sorted the rows in an Excel worksheet or entered the data in such a way 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 of the cells that contain data, and then open the Subtotal dialog box.
In the Subtotal dialog box, you can choose the column on which to base your subtotals (such as every change of value in the ...
Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
