Page 7 of 10PREVNEXT

PivotTable II: Filter PivotTable report data in Excel 2007

Removing filter by using icon next to Row Labels or icon in PivotTable Field List

Callout 1 Removing a filter in the PivotTable report by clicking the filter icon Icon image, and then clicking Clear Filter From "Product Category".
Callout 2 Removing a filter in the PivotTable Field List by moving the cursor over the filter icon Button image next to the field name, clicking the arrow that appears, and then clicking Clear Filter From "Product Category".

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 Icon image, and in the PivotTable Field List Button image.

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 Icon image 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 Button image 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.

Page 7 of 10PREVNEXT