Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

NOTE If you clear an outline by mistake, you cannot use the Undo feature to reverse the action; instead, you must recreate the outline.



P ROCEDURES

1. Select a single cell in the worksheet. 2. Select the Data tab on the Ribbon .

3. Select the bottom part of the Ungroup button

in the Outline group.

4. Select Clear Outline .



S TEP - BY -S TEP Clear an outline from a worksheet.

If necessary, go to the District 2 worksheet.

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 Ungroup button in the Outline group. The Ungroup menu opens.

Click cell A1

Click Data

Click

4. Select Clear Outline .

Click Clear Outline

The outline is cleared from the current worksheet and the outline symbols are removed.

Practice the Concept: Select the District 1 worksheet tab. Select the range B3:D6 then click the bottom part of the Ungroup button and select the Clear Outline option. Notice that outlining is cleared only from the selected area of the worksheet.

OFFICEPRO, Inc.

Page 77