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.