O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Problem

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required