Do you want to see the hidden data again, to look at the big picture? You can go slow and easy by removing filters one at a time, or you can quickly remove all filters at once.
The key to removing filters one at a time is using the filter icon, which appears in two different places: on the PivotTable report , and in the PivotTable Field List .
To remove all filters at once, you use commands on the Ribbon at the top of the window.
Remove a filter in the PivotTable report
To remove a filter from a specific field, click the filter icon wherever the filtered field appears in the report, either on Row Labels or on Column Labels. Then click Clear Filter From <Field Name>. Or select the check box next to (Select All) to make all data in that field visible.
If you do not see the Clear Filter From command for the filtered field:
- Be sure that you have selected the correct area of the report to clear the filter from: either rows or columns.
- Is the correct field name in the Select field box? You see that box when you click the filter icon. The field name in that box must match the name of the field you want to clear the filter from. If the field name in the box is incorrect, select the correct field from the list that appears when you click the arrow next to the box.
Remove a filter in the PivotTable Field List
Move the cursor over the filter icon next to the field name you want to remove the filter from. Click the arrow that appears, and then click Clear Filter From <Field Name>. Or select the check box next to (Select All) to make all data in the field visible.
Remove all filters at one time
At the top of the window, on the Ribbon, click the Options tab under PivotTable Tools. In the Actions group, click Clear, and then click Clear Filters. Be sure you really want to do this before you undo all your selections.