Microsoft Office Tutorials and References
In Depth Information
You can remove a group by selecting the rows in the group and then, in the Outline
group, clicking Ungroup.
Tip If you want to remove all subtotals from a worksheet, open the Subtotal dialog box, and
click the Remove All button.
In this exercise, you’ll add subtotals to a worksheet and then use the outline that appears
to show and hide different groups of data in your worksheet.
SET UP You need the GroupByQuarter_start workbook located in your Chapter06
practice file folder to complete this exercise. Open the GroupByQuarter_start
workbook, and save it as GroupByQuarter . Then follow the steps.
1. Click any cell in the data list.
2. On the Data tab, in the Outline group, click Subtotal .
The Subtotal dialog box opens with 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.