Excel PivotTablesLesson 66Free preview

Excel PivotTable Filter

This lesson is part of Excel · All levels

Summary

Filters on the PivotTable limit the data that is summarized without touching the source sheet, for example displaying only one region or a specific date range. You can use the Filters area, the arrow on the line label, or the Slicer that appears as an interactive button. The change in filters immediately updates the entire report.

Key points

Area Filters filter the entire report based on one field
Arrows on the label filter out certain items
The slicer provides a visual button for a quick filter
The filter only affects the pivot view, not the source data.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.