Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

NOTE You cannot undo the Show Report Filter Pages feature. To remove a report filter field report, you must delete the worksheet on which it appears. You can double-click any data field item to display its details on a separate worksheet.



P ROCEDURES

1. Select the Analyze tab . 2. Select the right-hand part of the Options button

in the PivotTable group.

3. Select the Show Report Filter Pages command. 4. Select the report filter field for which you want to create report filter field reports. 5. Select .



S TEP - BY -S TEP

Create Report Filter Pages.

If necessary, display the Sheet1 worksheet.

Drag the Region field from the PivotTable Field List pane to a position below the Year field in the Report Filter box.

Steps

Practice Data

1. Select the Analyze tab.

Click Analyze.

The Analyze tab is displayed.

2. Select the right-hand part of the Options button in the PivotTable group. The Options menu opens. 3. Select the Show Report Filter Pages command. The Show Report Filter Pages dialog box opens 4. Select the report filter field for which you want to create report filter pages. The report filter field is selected.

Click Options

Click Show Report Filter Pages

Click Region

Page 118

OFFICEPRO, Inc.