Remove filters to display all data in a PivotTable list

Office PivotTable

Show All

Remove filters to display all data in a PivotTable list

When items in a field are hidden by filtering a field or filtering by selection, the arrow Field arrow in the field label is blue. When items are hidden by filtering for top or bottom values, the filtered field displays a funnel image to the left of the arrow.

Note   If you don't want to retain your filters, make sure the AutoFilter button is not selected before you start selecting items to filter. If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.