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

242 Reorganizing the Worksheet
table data are displayed in the worksheet. By clicking the appropriate row or column level symbol, you can immediately hide detail rows and columns to display just the summary information in the table. For example, Figure 4-6 shows you the CG Media Sales table after clicking the number 2 Row Level button and number 2 Column Level button. Here, you see only the first- and second-level summary information, that is, the totals for the quarterly and annual totals for the two types of media.
Figure 4-6:
Collapsed worksheet outline showing first- and secondary- level summary information.
You can also hide and display levels of the outlined data by positioning the cell cursor in the column or row and then clicking the Hide Detail (the one with the red minus sign) or the Show Detail button (the one with the green minus sign) in the Outline group of the Data tab of the Ribbon. Or you can press the hot keys, Alt+AH, to hide an outline level, and Alt+AJ to redisplay the level. The great thing about using these command buttons or their hot key equivalents is that they work even when the outline symbols are not dis- played in the worksheet.
Figure 4-7 shows you the same table, this time after clicking the number 1 Row Level button and number 1 Column Level button. Here, you see only the first-level summary for the column and the row, that is, the grand total of the annual CG Media sales. To expand this view horizontally to see the total sales for each quarter, you would simply click the number 2 Column Level button. To expand this view even further horizontally to display each