Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

Using a report filter field item to filter data



P ROCEDURES 1. Select the desired field name from the field section in the PivotTable Field List pane and drag to the Report Filter box in the layout section.

2. Release the mouse button. 3. Click the report filter field list 4. Select the desired item. 5. Select .

.



S TEP - BY -S TEP Select a report filter field item.

If necessary, display the Sheet1 worksheet.

Steps

Practice Data

1. Select the desired field name from the field section in the PivotTable Field List pane and drag to the Report Filter box in the layout section. The selected field name is highlighted and the mouse pointer changes to a move handle. The field name label appears as you drag to the desired location in the layout section.

Drag the SalesRep field to the Report Filter box

Page 106

OFFICEPRO, Inc.