Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

As you move fields in the PivotTable report, thick bars indicate the placement of the field. Vertical bars represent row area placement and horizontal bars represent column and page area placement.

NOTE For greater ease of use, you can move the PivotTable Field List pane to either side of the window. You can also undock the PivotTable Field List pane and resize it both vertically and horizontally to suit your needs. You can also right-click a field name and choose its location from the shortcut menu. In previous versions of Excel, you could also drag field names from the Field List directly onto the appropriate areas of the PivotTable report worksheet. You can still drag From the ribbon, click Analyze > Show group > Field List . The PivotTable Fields pane opens. Drag a field and drop it in the appropriate location on the table. You can also move a field from one area to another by dragging the desired field from the PivotTable Fields pane to the desired area; the field is removed from its previous area and appears only in the destination area.



P ROCEDURES 1. Select the desired field name from the relevant area in the lower half of the PivotTable Fields pane and drag to the required area. 2. Release the mouse button.  S TEP - BY -S TEP Move a PivotTable report field.

If necessary, display the Sheet1 worksheet.

Page 112

OFFICEPRO, Inc.