Excel® 2007 PivotTables and PivotCharts

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 VBA to toggle the PivotTable Field List, as shown in the following macro:

Example

Sub ToggleFieldList()
 '
 ' Work with the active workbook
 '
 With ActiveWorkbook
 '
 ' Toggle the current value of the
 ' workbook's ShowPivotTableFieldList
 ' property between True and False
 '
 .ShowPivotTableFieldList = Not
.ShowPivotTableFieldList
 End With
End Sub

Turn the PivotTable Field List on and Off

Turn Off the PivotTable Field List

Note: This chapter uses the Orders.xlsm and PivotTables.xlsm spreadsheets, available at www.wiley.com/go/2007pivottablesvb, or you can create your own sample database.

1. Click inside the PivotTable.

2. Click Options→Field List.

   • You can also click the Close button.

     Excel turns off the PivotTable Field List.

Turn On the PivotTable Field ...