Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.3 Filter and Sort a Table: Filter Records (Clear Filters)

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.

Data -> Sort & Filter-> Clear