O'Reilly logo

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets by Paul McFedries

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 3. Manipulating Your PivotTable

Turn the PivotTable Toolbar On and Off

You can make your PivotTable chores quicker and easier by taking advantage of the buttons on the PivotTable toolbar. Most of these buttons give you one-click access to the most PivotTable features. You can also click the PivotTable button to display a list of commands available for your PivotTables.

Normally the PivotTable toolbar appears automatically when you create a PivotTable. When you click a cell outside the PivotTable, the PivotTable toolbar disappears, and it reappears when you click a cell within the PivotTable. However, you can also turn the PivotTable toolbar on and off by hand. For example, if your PivotTable report takes up all or most of the screen, you ...

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