Datasheet

594
Subtotaling Data
As you can see in Figure 1-14, when you use the Subtotals command, Excel
outlines the data at the same time that it adds the rows with the departmen-
tal salary totals and the grand total. This means that you can collapse the
data list down to just its departmental subtotal rows or even just the grand
total row simply by collapsing the outline down to the second or first level.
(Remember that you can toggle between showing and hiding the outline
symbols at the left edge of the data list by pressing Ctrl+8.)
In a large data list, you may want Excel to insert page breaks (often referred
to as a break) every time data changes in the field on which the list is being
subtotaled (that is, the field designated in the At Each Change In drop-down
list box). To do this, you simply click the Page Break between Groups check
box in the Subtotal dialog box to put a check mark in it before you click OK
to subtotal the list.
30_489598-bk06ch01.indd 59430_489598-bk06ch01.indd 594 3/27/10 12:46 PM3/27/10 12:46 PM