Microsoft Office Tutorials and References
In Depth Information
Extending the outline to new worksheet areas
When you use nonstandard worksheet layouts, be sure the area you want to outline is
consistent to avoid unpredictable and possibly incorrect results; that is, be sure all summary
formulas appear in the same direction relative to the detail data. After you select or clear
one or both Direction options, click the Create button to create the outline.
Extending the outline to new worksheet areas
At times, you might create an outline and then add more data to your worksheet. You
might also want to re-create an outline if you change the organization of a specific
worksheet area. To include new columns and rows in your outline, repeat the procedure you
followed to create the outline in the first place: select a cell in the new area, and click Auto
INSIDE OUT Just say no to automatic styles
In the Settings dialog box, the Automatic Styles check box and the Apply Styles button
apply rudimentary font formats to your outline that help distinguish totals from detail
data. Unfortunately, this isn’t very effective. To ensure that the outline is formatted the
way you want, you should plan to apply formats manually.
Hiding an outline
When you outline a worksheet, Excel displays symbols above and to the left of the row and
column headings (as you can see in Figure 8-72). These symbols take up screen space, so
if you want to suppress them, you can click the File tab, Options; then click the Advanced
category, and clear the Show Outline Symbols If An Outline Is Applied check box in the
Display Options For This Worksheet area. However, this makes it harder to tell whether there is
an outline present on the worksheet.
Collapsing and expanding outline levels
When you create an outline, the areas above and to the left of your worksheet are marked
by one or more brackets that terminate in hide detail symbols, which have minus signs on
them. The brackets are called level bars . Each level bar indicates a range of cells that share
a common outline level. The hide detail symbols appear above or to the left of each level’s
summary column or row. If you have hidden the outline symbols or if you prefer to use the
ribbon, you can also use the Show Detail and Hide Detail buttons in the Outline group on
the Data tab to collapse and expand your outline.
Search JabSto ::

Custom Search