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

Reorganizing the Worksheet 245
Before you use the Group and Ungroup buttons to change an outline level, you must select the rows or columns that you want to promote or demote. To select a particular outline level and all the rows and columns included in that level, you need to display the outline symbols (Ctrl+8), and then hold down the Shift key as you click its collapse or expand symbol. Note that when you click an expand symbol, Excel selects not only the rows or col- umns visible at that level, but all the hidden rows and columns included in that level as well. If you want to select only a particular detail or summary row or column in the outline, you can click that row number or column letter in the worksheet window, or you can hold down the Shift key and click the dot (period) to the left of the row number or above the column letter in the outline symbols area.
If you select only a range of cells in the rows or columns (as opposed to entire rows and columns) before you click the Group and Ungroup com- mand buttons, Excel displays the Group or Ungroup dialog box, which con- tains a Rows and Columns option button (with the Rows button selected by default). To promote or demote columns instead of rows, click the Columns option button before you select OK. To close the dialog box without promot- ing or demoting any part of the outline, click Cancel.
To see how you can use the Group and Ungroup command buttons on the Data tab of the Ribbon to adjust outline levels, consider once again the CG Media Sales table outline. When Excel created this outline, the program did not include row 3 (which contains only the row heading, Downloads) in the outline. As a result, when you collapse the rows by selecting the number
1 Row Level button to display only the first-level Total Sales summary row (refer to Figure 4-7), this row heading remains visible in the table, even though it should have been included and thereby hidden along with the other summary and detail rows.
You can use the Group command button to move this row (3) down a level so that it is included in the first level of the outline. You simply click the row number 3 to select the row and then click the Group command button on the Data tab (or press Alt+AGG). Figure 4-9 shows you the result of doing this. Notice how the outside level bar (for level 1) now includes this row. Now, when you collapse the outline by clicking the number 1 row level button, the heading in row 3 is hidden as well. (See Figure 4-10.)
Book II Chapter 4
Managing Worksheets