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

Reorganizing the Worksheet 241
Figure 4-5:
Worksheet outline after applying automatic styles with the Settings dialog box.
The RowLevel_1 style is applied to the entries in the first-level summary row (row 21) and makes the font appear in bold. The ColLevel_1 style is applied to the data in the first-level summary column (column R, which isn’t shown in the figure), and it, too, simply makes the font bold. The RowLevel_2 style is applied to the data in the second-level rows (rows 8 and 20), and this style adds italics to the font. The ColLevel_2 style is applied to all second-level summary columns (columns E, I, M, and Q), and it also italicizes the font.
Sometimes Excel can get a little finicky about applying styles to an existing outline. If, in the Settings dialog box, you select the Automatic Styles check box, click the Apply Styles button, and nothing happens to your outline, simply click the OK button to close the Settings dialog box. Then, re-create the outline by selecting the Auto Outline option on the Group drop-down list on the Data tab. Excel displays an alert dialog box asking you to confirm that you want to modify the existing outline. As soon as you click OK, Excel redis- plays your outline, this time with the automatic styles applied.
Displaying and hiding different outline levels
The real effectiveness of outlining worksheet data becomes apparent only when you start using the various outline symbols to change the way the
Book II Chapter 4
Managing Worksheets