Excel 2016 Tips and Tricks

Excel 2016

Lesson 4 – Creating/Revising PivotTables

H IDING /U NHIDING P IVOT T ABLE R EPORT I TEMS  D ISCUSSION

You do not have to display all the field items in a PivotTable report. You can hide selected items, such as some of the products in a Product field. You can hide everything except the data you need to view.

You can also unhide items at any time. To unhide items, you follow the same procedure as you do when hiding items; you simply select the items you want to view in the field item list or select (Select All) to view all the field items.

Hiding field items



P ROCEDURES 1. Select the

beside the column header list to display the items you want to

hide or unhide. 2. Click the checkbox beside the items you want to hide to deselect the item you

want to hide, or select the item you want to unhide. 3. Continue deselecting or selecting items as desired. 4. Click .



S TEP - BY -S TEP Hide and unhide items in a PivotTable report.

If necessary, display the Sheet1 worksheet.

OFFICEPRO, Inc.

Page 115