The Pivot Table allows you to filter data by specifying a range of cell values that should be displayed. Values that do not fall into this range will be hidden.

Topics in this section describe how to configure filtering by cell values (or summary filtering).

The following topics are available.

•Invoke a Summary Filter Window

Describes how to invoke a Summary Filter Window used to enable and configure filtering by cell values.

•Select a Range of Values

Shows how to specify a range of cell values that should be displayed.

•Move the Selected Range

Demonstrates how to select another range with the same length by moving the selection.

•Zoom and Move the Viewport

Describes how to zoom and scroll the range selector.

•Specify Target Cells

Shows how to enable filtering by Total and Grand Total cells.

•Remove Filtering

Describes how to disable filtering.