Page 257 - Excel 2013 All-in-One For Dummies

Reorganizing the Worksheet 239
Simply start by clicking the Dialog Box launcher in the lower-right corner of the Outline group on the Data tab of the Ribbon to open the Settings dialog box. In the Settings dialog box, clear the check marks from the Summary Rows below Detail and/or Summary Columns to Right of Detail check boxes in the Direction section. Also, you can have Excel automatically apply styles to different levels of the outline by selecting the Automatic Styles check box. (For more information on these styles, see the “Applying outline styles” sec- tion, later in this chapter.) To have Excel create the outline, click the Create button — if you click the OK button, the program simply closes the dialog box without outlining the selected worksheet data.
Figure 4-4 shows you the first part of the outline created by Excel for the CG Media 2012 Sales worksheet. Note the various outline symbols that Excel added to the worksheet when it created the outline. Figure 4-4 identifies most of these outline symbols (the Show Detail button with the plus sign is not displayed in this figure), and Table 4-1 explains their functions.
Figure 4-4:
Automatic outline applied
to the CG Media sales table with three levels of detail displayed.
Book II Chapter 4
Managing Worksheets