Outlining Data
Outlining provides a structure to your worksheet to quickly hide or display detail and summary information. Your worksheet should already contain summary rows. You can outline automatically or manually. When you create subtotals, you automatically create an outline.
Use the following procedure to create an outline.
- Select the range of cells to include in the outline.
- Select the Data tab from the Ribbon.
Select the small square in the corner of the Outline group.
In the Settings dialog box, check the direction of the summary rows and columns.
Check the Automatic styles box to have Excel automatically apply styles to the outline.
Select Create.