Microsoft Office Tutorials and References
In Depth Information
Organizing data into levels
SET UP You need the GroupByQuarter workbook located in the Chapter06 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
Click any cell in the data list. Then, on the Data tab, in the Outline group, click
Subtotal to open the Subtotal dialog box. The Subtotal dialog box displays the
default options to add a subtotal at every change in the Year column, to return the sum
of the values in the subtotaled rows, and to add a row with the subtotal of values in
the Package Volume column below the final selected row.
Click OK to close the Subtotal dialog box. New rows appear with subtotals for
package volume during each year represented in the worksheet. The new rows are
numbered 14 and 27 . A row that contains the grand total of all rows also appears; that
row is row 28 . A new area with outline bars and group-level indicators appears to the
left of column A .