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

240 Reorganizing the Worksheet
Table 4-1
Button
Row Level (1-8) and Column Level (1-8)
Show Detail (+) Hide Detail (–)
Outline Buttons
Function
Displays a desired level of detail throughout the outline (1,
2, 3, and so on up to 8). When you click an outline’s level bar rather than a numbered Row Level or Column Level button, Excel hides only that level in the worksheet display, the same as clicking the Hide Detail button (explained below).
Expands the display to show the detail rows or columns that have been collapsed.
Condenses the display to hide the detail rows or columns that are included in its row or column level bar.
If you don’t see any of the outline doodads identified in Figure 4-4 and Table 4-1, this means that the Show Outline Symbols If an Outline Is Applied check box in the Displays Options for This Worksheet section of the Advanced tab in the Excel Options dialog box (Alt+FTA) is not checked. All you have to do
is press Ctrl+8 to display the outline symbols. Keep in mind that Ctrl+8 is a toggle that you can press again to hide the outline symbols.
You can have only one outline per worksheet. If you’ve already outlined one table and then try to outline another table on the same worksheet, Excel will display the Modify Existing Outline alert box when you choose the Outline command. If you click OK, Excel adds the outlining for the new table to the existing outline for the first table (even though the tables are nonadjacent). To create separate outlines for different data tables, you need to place each table on a different worksheet of the workbook.
Applying outline styles
You can apply predefined row and column outline styles to the table or list data. To apply these styles when creating the outline, be sure to select the Automatic Styles check box in the Settings dialog box before you click its Create button, opened by clicking the Dialog Box launcher in the Outline group on the Data tab of the Ribbon. If you didn’t select this check box in the Settings dialog box before you created the outline, you can do so afterwards by selecting all the cells in the outlined table of data, opening the Settings dialog box, clicking the Automatic Styles check box to put a check mark in it, and then clicking the Apply Styles button before you click OK.
Figure 4-5 shows you the sample CG Media Sales table after I applied the automatic row and column styles to the outlined table data. In this example, Excel applied two row styles (RowLevel_1 and RowLevel_2) and two column styles (ColLevel_1 and ColLevel_2) to the worksheet table.