Microsoft Office Tutorials and References
In Depth Information
The level buttons are the other buttons in the outline area of a worksheet with subtotals.
Each button represents a level of organization in a worksheet; clicking a level button hides
all levels of detail below that of the button you clicked. The following table describes the
data contained at each level of a worksheet with three levels of organization.
Subtotals for each group
Individual rows in the worksheet
Clicking the Level 2 button in the worksheet would hide the rows with data on, for
example, each month’s revenue but would leave the row that contains the grand total
(Level 1) and all rows that contain the subtotal for each year (Level 2) visible in the
If you like, you can add levels of detail to the outline that Excel creates. For example,
you might want to be able to hide revenues from January and February, which you
know are traditionally strong months. To create a new outline group within an existing
group, select the rows you want to group; on the Data tab, in the Outline group, point
to Group, and then click Group.