How to remove a filter depends on how many filters you have applied, and on how many filters you wish to remove.
One column To remove a filter from a single column, click the AutoFilter arrow next to the column, and then click (All). That will display the data that was hidden by that filter.
All columns To remove all filters at once, point to Filter on the Data menu, and then click Show All. That will display all hidden data but leave AutoFilter turned on.
AutoFilter To turn off AutoFilter, point to Filter on the Data menu, and then click AutoFilter.
Remember, filtering doesn't change your data in any way. As soon as you remove the filter, all your data reappears, exactly the same as it was before.
Note This course discusses how to use AutoFilter arrows that are inserted by using the AutoFilter command on the Data menu. Another way to use AutoFilter arrows is to use the List command, which is a new feature in Microsoft Office Excel 2003. You can learn how to use the new list feature in Lists I: How to use lists in Excel 2003.
