Remove filters
- To remove a filter applied to one column in a range or a list, click the arrow
next to the column, and then click All. - To remove filters applied to all columns in a range or list, point to Filter on the Data menu, and then click Show All.
- To remove the filter arrows from a range or list, point to Filter on the Data menu, and then click AutoFilter.