To see if a column is filtered, click the drop-down arrow in the column header. If a column has a filter, an entry other than Show All will be selected in the drop-down list.
To remove a filter from a column
- Click the drop-down arrow in the column header.
- Click Show All in the list.
To remove all filters and sorting orders
- On the task pane toolbar, click Remove Filter/Sort.