Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

The Settings dialog box

NOTE Changes to outline settings apply only to the current worksheet. This allows you to use different settings in each sheet in a workbook. You can create an outline as you change the outline settings by using the Create button in the Settings dialog box. You must select the columns or rows you wish to outline before opening the Settings dialog box.



P ROCEDURES

1. Select the worksheet in which you want to change the outline settings. 2. Select the Data tab on the Ribbon . 3. Select the Outline launcher arrow . 4. Select or deselect the desired options. 5. Select OK .



S TEP - BY -S TEP

Modify outline settings.

Steps

Practice Data

1. Select the worksheet in which you want to change the outline settings. The selected worksheet is displayed.

Click the District 2 worksheet tab

2. Select the Data tab on the Ribbon . The Data tab is displayed.

Click Data

3. Select the Outline launcher arrow. The Settings dialog box opens.

Select Outline

OFFICEPRO, Inc.

Page 73