Chapter 3. MANIPULATING YOUR PIVOTTABLE

Turn the PivotTable Field List On and Off

You can give yourself more room to display your PivotTable report by turning off the PivotTable Field List when you do not need it. You can then turn the PivotTable Field List back on when you need to add, move, or delete fields.

By default, when you click inside the PivotTable, Excel displays the PivotTable Field List, and then hides the PivotTable Field List again when you click outside of the PivotTable report. However, if you want to work with the PivotTable Tools, then you need to leave at least one cell in the PivotTable report selected. Fortunately, Excel also enables you to turn the PivotTable Field List off and on by hand.

You can also use the programming language ...

Get Excel® PivotTables and PivotCharts: Your visual blueprint™ for creatingdynamic spreadsheets, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.