Excel 2019 Bible

Part IV: Managing and Analyzing Data

FIGURE 27.1

A simple sales summary with subtotals

FIGURE 27.2

The worksheet after creating an outline

Figure 27.3 depicts the outline after clicking the 2 header, which collapses everything

below the second level of details. Now the outline shows only the totals for the regions. You