Data: Clear the Filters

You can clear the data filters if you wish. Here are the steps.

 

5. Try it: Clear the Filters

Select Column E (City).

Go to Data -> Sort & Filter.

Click on Clear.

 

What Do You See?  This option removes all of the Filters on the City field. In the example on this page, the filter for MyTown has been cleared, so you can see other cities as well.

 

Very good. That's a short discussion on Filters. Save your work.

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.1. Filter data: Clear a Filter

Data -> Sort & Filter-> Clear