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

244 Reorganizing the Worksheet
Figure 4-8:
Worksheet outline expanded to show only details for CD sales
for all four quarters.
Excel adjusts the outline levels displayed on the screen by hiding and redis- playing entire columns and rows in the worksheet. Therefore, keep in mind that changes that you make that reduce the number of levels displayed in the outlined table also hide the display of all data outside of the outlined table that are in the affected rows and columns.
After selecting the rows and columns you want displayed, you can then remove the outline symbols from the worksheet display to maximize the amount of data displayed onscreen. To do this, simply press Ctrl+8.
Manually adjusting the outline levels
Most of the time, Excel’s Auto Outline feature correctly outlines the data
in your table. Every once in a while, however, you will have to manually adjust one or more of the outline levels so that the outline’s summary rows and columns include the right detail rows and columns. To adjust levels of a worksheet outline, you must select the rows or columns that you want to promote to a higher level (that is, one with a lower level number) in the out- line and then click the Group button on the far right side of the Data tab of the Ribbon. If you want to demote selected rows or columns to a lower level in the outline, select the rows or columns with a higher level number and then click the Ungroup button on the Data tab.