Microsoft Office Tutorials and References
In Depth Information
Group Related Data
11
chapter
Analyzing Data
Use the Outline to Control the
Range Display
1 Click a Collapse symbol ( ) to
hide the range indicated by
the level bar.
D You can also collapse multiple
ranges that are on the same
outline level by clicking the
appropriate level symbol.
E Excel collapses the range.
2 Click the Expand symbol (
)
to view the range again.
F You can also show multiple
ranges that are on the same
outline level by clicking the
appropriate level symbol.
Do I have to prepare my worksheet before I can group the data?
Yes. 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 will not outline a worksheet with, say, SUM( ) functions that reference ranges
above and below a formula cell.
Search JabSto ::




Custom Search