Part IV: Managing and Analyzing Data
Figure 27.6 shows a worksheet with a three-level outline of this book. We had to create it
manually because it has no formulas, just text.FIGURE 27.6
An outline of this book, created manuallyThis workbook is available on this book’s website at http://www.wiley.com/go/excel2019bible. The
file is named book outline.xlsx.Working with Outlines
This section discusses the basic operations that you can perform with a worksheet outline.Displaying levels
To display various outline levels, click the appropriate outline symbol. These symbols con-
sist of headers with numbers on them (1, 2, and so on) or a plus sign (+) or minus sign (–).
Refer to Figure 27.5, which shows these symbols for a row and column outline.Clicking the 1 header collapses the outline so that it displays no detail (just the high-
est summary level of information), clicking the 2 header expands the outline to show one
level, and so on. The number of headers depends on the number of outline levels. Choosing