How to Clear Pivot Table Filters

In this example, we have only NC and SC showing in our Pivot Table, but we need all values to be showing.

In order to see all of our states in the Pivot Table, we need to clear our Pivot filters.

Microsoft Pivot Table that is filtered.

To do so click the arrow by row labels and Clear the filter from whatever the row label header is. In this case, the State.

The quickest and more advanced way of quickly clearing your Pivot Table filter is via hotkeys: ALT>A>C.

Click here for other common hotkeys used for PivotTables

Clearing filter from the row label in a Pivot.

Now we can see all of our data in the Pivot.

Unfiltered Microsoft Pivot Table.

Click here for help with filtering a PivotTable

summary

  • It can be easy to forget data is filtered
  • Clearing filters is fast and easy with our "auto clear" acronym
  • One can clear filters or change filtered items in the column directly