CHAPTER 6Modifying a Pivot Table

After you create a pivot table, you can modify it. You can move the fields to a different part of the pivot table, add or remove fields, show or hide items, and make other changes. For some of these tasks, you can use the PivotTable toolbar, which you can also modify, to make your work easier.

6.1. Using Page Fields: Shifting Up When Adding Page Fields


In the rows above your pivot table, you've entered some worksheet heading text. You dragged another field to the page area, below the existing page field (see Figure 6-1). When you release the mouse button, you get a warning: "Do you want to replace the contents of the destination cells in PivotSheet?" If you click OK, the page fields move up and remove ...

Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.