Microsoft Office Tutorials and References
In Depth Information
One More Example—Function Applied to Multiple Categories
FIGURE 25.3 Subtotal Menu
Looking at Figure 25.4, you can see how data is grouped and outlined. You can use
the outline symbols , ,and to either display or collapse the groupings,
according to your presentation needs. I clicked on the level 2 button, as you can see in
ONE MORE EXAMPLE—FUNCTION APPLIED TO MULTIPLE
Using the same data set, call up the same menu to remove the subtotals. Sort by a
different parameter and start again:
Click on Subtotal again and in the pop-up menu, select Remove All. Figure 25.6
displays how to do it.
Sort the data again
this time sort it by Job.
Create a new Subtotal. This time choose Max for both Age and Seniority.
Collapse the report using the grouping menu. See Figure 25.7.
COPYING GROUPED DATA
When data is grouped or filtered
as in the case of using the Subtotal function
many of the rows are hidden. Lines 2
8 are hidden in Figure 25.7. So are lines 10
21. If you attempt to copy the data and paste it somewhere else, the complete
data set will be pasted, including the hidden data. See Figure 25.8.