Microsoft Office Tutorials and References
In Depth Information
If you’d rather display as much PivotTable data as possible, you can hide the PivotTable
Field List task pane and filter the PivotTable by using the filter arrows on the Row Labels
and Column Labels headers within the body of the PivotTable. Clicking either of those
headers enables you to select a field by which you can filter; you can then define the
filter by using the same controls you see when you click a field header in the PivotTable
Field List task pane.
Excel indicates that a PivotTable has filters applied by placing a filter indicator next to the
Column Labels or Row Labels header, as appropriate, and the filtered field name in
the PivotTable Field List task pane.