After applying a sort or filter you have the option to clear it. Clearing a filter can apply to a specific column by right-clicking on the column and selecting Clear Filter, or to all filtered columns by selecting to clear the filter from the TABLE tab.
To clear a sort or filters from a table:
On the TABLE tab, in the Sort and Filter group, click:
- Filter, and Clear Filter.
- Sort, and Clear Sort.
To clear both sort and filters at the same time, on the TABLE tab, in the Sort and Filter group, click Clear All.
Selecting to clear a sort or filter refreshes the Browser window.