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.