Excel 2016 Data and List Management

Lesson 3 – Working with Outlines

Excel 2016

Steps

Practice Data

1. Select a single cell in the worksheet. The cell is selected. 2. Select the Data tab on the Ribbon . The Data tab is displayed. 3. Select the bottom part of the Group button in the Outline group. The Group menu opens.

Click cell A1

Click Data

Click

4. Select Auto Outline .

Click Auto Outline

Excel creates an outline based on the position of detail and summary columns and rows in the worksheet and outline symbols appear above and to the side of the worksheet.

Practice the Concept: Collapse and expand the outline as desired. Notice that Excel has created multiple levels.

C LEARING AN O UTLINE  D ISCUSSION

You can remove all outline levels to clear an outline from a worksheet. Although all the data remains on the worksheet, the distinctions between detail and summary data are removed.

NOTE You can clear outlining from part of a worksheet by selecting a range of cells before choosing the Clear Outline option. If a single cell is selected, the Clear Outline option removes all outlining in the current worksheet. You can ungroup parts of an outline by selecting grouped rows or columns and clicking the top part of the Ungroup button in the Outline group on the Data tab. This action promotes the selected rows or columns to the next highest level.

Page 76

OFFICEPRO, Inc.