Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

Using Expand and Collapse buttons



P ROCEDURES

1. Select the Collapse button report details. 2. Select the Expand button

to the left of the desired field value to collapse the

to the left of the desired field value to show the

report details.



S TEP - BY -S TEP Using the Expand and Collapse buttons.

Steps

Practice Data

1. Select the Collapse button to the left of the desired field value to collapse the report details. The list of information is collapsed as appropriate. 2. Select the Expand button to the left of the desired field value to show the report details. The list of information is expanded as appropriate.

Click the Collapse button to the left of Athlete’s Dream

Click the Expand button to the left of Athlete’s Dream

Page 114

OFFICEPRO, Inc.