Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

Applying a PivotTable style

NOTE

To switch from one layout to another, select the PivotTable Tools contextual Design tab, in the PivotTable Styles Options group, click the More button to display the layout options then select the required layout. If you create Report Filter Pages for a formatted PivotTable report, each new page will be formatted the same as the original PivotTable report. Selecting Clear from the PivotTable Styles menu removes all formatting from a PivotTable report.



P ROCEDURES 1. Select the PivotTable Tools contextual Design tab. 2. Select the More button in the PivotTable Styles group. 3. Select the desired style.  S TEP - BY -S TEP If necessary, display the Sheet1 worksheet Click anywhere in the PivotTable report to activate it.

Page 120

OFFICEPRO, Inc.