- Click the AutoFilter button
on the toolbar so that it is not selected.
Note If you click AutoFilter
again to turn filtering back on, the previously set filters will be reapplied.
Remove an autofilter from a field
- Click the blue arrow
of the field from which you want to remove the filter. - Select the (All) check box and click OK.
- Select the series or point from which you want to remove conditional filtering.
- Click Show Top/Bottom Items
on the toolbar, and then click Show All.
Notes
- 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.