Excel 2016 Data and List Management

Lesson 3 – Working with Outlines

Excel 2016

Practice the Concept: Drag to select B3:I6 and apply an outline to the rows by clicking the top part of the Group button and selecting the Rows option in the Group dialog box. Select OK to apply the outline and close the dialog box. Select rows 11 through 14 and apply an outline to the rows by clicking the top part of the Group button. Click any cell to deselect the range.

C OLLAPSING /E XPANDING AN O UTLINE  D ISCUSSION

Once you have grouped rows and/or columns into an outline, Excel displays Outline Level buttons (numbered 1, 2, 3, etc., up to 8 levels) at the top-left of the spreadsheet frame. Column Outline Level buttons appear above the row numbers; Row Outline Level buttons appear to the left of the column letters. You can use these buttons to collapse and expand entire outline levels.

The highest numbered Column Outline Level or Row Outline Level button displays all detail levels for columns or rows accordingly. Each lower numbered button collapses all higher numbered levels to hide the detail columns or rows.

Excel also displays Group Level buttons above grouped columns and beside grouped rows. These buttons let you collapse or expand individual groups within a level. Collapsing a group hides the detail data for that group. Expanding a group displays the detail data for that group.

Expanding and collapsing outline groups or levels lets you control how much data appears on the screen as well as how much data is printed.

Page 70

OFFICEPRO, Inc.