Excel 2016 Data and List Management

Lesson 3 – Working with Outlines

Excel 2016

Steps

Practice Data

1. To collapse an outline level, select the desired Column Outline Level or Row Outline Level button. The detail columns or rows in higher numbered outline levels are hidden accordingly. 2. To expand an outline level, select the desired Column Outline Level or Row Outline Level button. The detail columns or rows of the selected outline level are displayed accordingly. 3. To collapse a single group within an outline level, click the group Hide Detail button. The detail columns or rows of the group are hidden accordingly. 4. To expand a single group within an outline level, click the group Show Detail button. The detail columns or rows of the group are displayed accordingly.

Click to the left of the column letters

Click to the left of the column letters

Click to the left of row 7

Click to the left of row 7

Practice the Concept: Collapse and expand the Sales detail rows by clicking the Hide Detail button above column E and then the Show Detail button. Select cell C12 and use the Hide Detail button in the Outline group on the Data tab to collapse both the column and row detail for February Sales. Use the Show Detail button in the Outline group on the Data tab to redisplay the February Sales detail columns and rows.

M ODIFYING O UTLINE S ETTINGS  D ISCUSSION

When you apply an outline to a worksheet, Excel assumes that the summary data is below the detail rows or to the right of the detail columns. If your worksheet is set up differently, you can change the default settings. You should change the settings before you apply the outlines.

Page 72

OFFICEPRO, Inc.