Excel 2019 Bible

(singke) #1

Part IV: Managing and Analyzing Data


FIGURE 27.7
Use the Settings dialog box to adjust the position of the outline symbols.

Hiding the outline symbols
The outline symbols that Excel displays when an outline is present take up quite a bit of
space. (The exact amount depends on the number of levels.) If you want to see as much as
possible on-screen, you can temporarily hide these symbols without removing the outline.
Press Ctrl+8 to toggle the outline symbols on and off. When the outline symbols are hidden,
you can’t expand or collapse the outline.

When you hide the outline symbols, the outline still is in effect, and the worksheet displays the data at the current
outline level. (That is, some rows or columns may be hidden.)

The Custom Views feature, which saves named views of your outline, also saves the status
of the outline symbols as part of the view, enabling you to name some views with the out-
line symbols and other views without them.
Free download pdf