Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

NOTE An outline can have up to eight levels of detail.

Excel assumes that the detail data for rows and columns appears above or to the left of the summary rows and columns. If this is not the case, you can change the direction by selecting the Data tab and clicking the Outline launcher arrow to display the Settings dialog box. If you select a range of cells in a worksheet, rather than entire columns or rows, Excel displays the Group dialog box when you click the Group button in the Outline group. You can then indicate how you want the cells grouped by selecting the Rows or Columns option in the Group dialog box.



P ROCEDURES

1. Select the rows or columns that contain the detail data. 2. Select the Data tab on the Ribbon .

3. Select the top part of the Group button

in the Outline group.



S TEP - BY -S TEP From the Student Data directory, open OUTLINE.XLSX . Apply an outline to a worksheet.

If necessary, go to the District 1 worksheet.

Steps

Practice Data

1. Select the rows or columns that contain the detail data. The rows or columns are selected.

Select column headings B through D, then release the mouse button

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

Click Data

3. Select the top part of the Group button in the Outline group. The selected rows or columns are

Click

grouped and outline symbols appear at the left or top of the worksheet accordingly.

OFFICEPRO, Inc.

Page 69