• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part IV: Optimizing Excel > Outlining Worksheets

Chapter 22. Outlining Worksheets

  • Understanding outlines

    Learn about the benefits of outlining and how outlines work with the symbols used in outline view.

  • Creating an outline

    Create an outline automatically using Excel's Automatic Outlining feature, or manually to give you more design control.

  • Modifying the outline display

    Vary the amount of detail displayed in an outline by hiding and displaying outline levels.

  • Charting from outlines

    Create charts from an outline, using only the visible data or all the data in the outline.

Outlining enables you to expand or contract worksheets or reports so that you see more or less detail. In a sales report, for example, you might need two levels of detail depending upon who will read it. For a regional sales manager reviewing the performance of salespeople, you might want a report with full detail. But a report for the divisional manager could only include summary information. With the outline feature, you can hide or display up to eight levels of detail in rows or columns.

The Data Subtotals feature in Excel uses outlining to organize different levels of subtotals. By using the outline feature directly, you can gain even more organizing ability.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint