Microsoft Office Tutorials and References
In Depth Information
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.
When you hide a group of rows, the button displayed next to the group changes to
a Show Detail button. Clicking a group’s Show Detail button restores the rows in the
group to the worksheet.