Microsoft Office Tutorials and References
In Depth Information
Create an Outline Automatically
Create an Outline
You can control a worksheet range display by
creating an outline automatically based on the
worksheet formulas and data.
Like Microsoft Word, Excel also offers
outlines. In a worksheet outline, you can
“collapse” sections of the sheet to display only
summary cells (such as quarterly or regional
totals) or you can “expand” hidden sections to
show the underlying detail.
The easiest way to create an outline is to have
Excel do it for you. Before you do this, you
need to make sure your worksheet is
appropriate for outlining. First, the worksheet
must contain formulas that reference cells or
ranges directly adjacent to the formula cell.
Worksheets with SUM() functions that subtotal
cells above or to the left are particularly good
candidates for outlining.
Second, there must be a consistent pattern to
the direction of the formula references. For
example, a worksheet with formulas that always
reference cells above or to the left can be
outlined. Excel won’t outline a worksheet
with, say, SUM() functions that reference
ranges above and below a formula cell.
Create the Outline
1 Display the worksheet
you want to outline.
2 Click the Data tab.
3 Click the Group
4 Click Auto Outline.
Excel outlines the
Excel uses level bars to
indicate the grouped
Excel displays level
symbols to indicate the
various levels of the
detail that are available
in the outline.