Microsoft Office Tutorials and References
In Depth Information
Create an Outline Automatically
Chapter 5: Analyzing Excel Data
Use the Outline to
Control the Range
Display
1 Click a collapse symbol to
hide the range indicated
by the level bar.
1
You can also collapse
multiple ranges that are
on the same outline level
by clicking the
appropriate level symbol.
Excel collapses the range.
2 Click the expand symbol
to view the range again.
2
You can also show
multiple ranges that
are on the same outline
level by clicking the
appropriate level symbol.
Did You Know?
Outlines are most useful for easily
hiding and displaying ranges. However,
one of the big advantages of outlines is
that, once you have hidden some data,
you can work with the visible cells as if
they were a single range. This means
that you can format those cells quickly,
print them, create charts, and so on.
Did You Know?
The level symbols that Excel displays for
outlined data tell you which level each level
bar is on. Click a level symbol to hide or
display all the detail data for that level.
Somewhat confusingly, Excel has set things
up so that lower outline levels have higher
level numbers. A good way to keep things
straight is to remember that the higher the
number, the more detail the level contains.
 
Search JabSto ::




Custom Search