Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

A collapsed outline

NOTE You can also use the Hide Detail and Show Detail buttons in the Outline group on the Data tab to expand and collapse an outline. To use these buttons you must first select a cell within the outline level group you wish to collapse or expand. If the cell you select is within both a column and a row outline level group, the Hide Detail or Show Detail button will collapse or expand both columns and rows at the same time.



P ROCEDURES

1. To collapse an outline level, select the desired Column Outline Level or Row Outline Level button , , etc. 2. To expand an outline level, select the desired Column Outline Level or Row Outline Level button , , etc. 3. To collapse a single group within an outline level, click the group Hide Detail button . 4. To expand a single group within an outline level, click the group Show Detail button .



S TEP - BY -S TEP Collapse and expand the details in an outline.

If necessary, go to the District 1 worksheet.

OFFICEPRO, Inc.

Page 71