Microsoft Office Tutorials and References
In Depth Information
Organizing data into levels
When you add subtotals to a worksheet, Excel also defines groups based on the rows used
to calculate a subtotal. The groupings form an outline of your worksheet based on the
criteria you used to create the subtotals. For example, all the rows representing months in the
year 2012 could be in one group, rows representing months in 2013 in another, and so on.
The outline area at the left of your worksheet holds controls you can use to hide or display
groups of rows in your worksheet.
Three types of controls can appear in the outline area: Hide Detail buttons, Show Detail
buttons, and level buttons. The Hide Detail button beside a group can be clicked to hide
the rows in that group. In a worksheet that has a subtotal group consisting of rows 2
through 13, clicking the Hide Detail button next to row 14 would hide rows 2 through 13
but leave the row holding the subtotal for that group, row 14, visible.