Data: Filter A Filter is a way to separate the customers you want to see from the ones you don't want to see. In Microsoft Excel, the Filters show or hide the Rows based on your criteria.   When you Filter the data, you can focus on part of the information. For example, you could look at the customers by City.   2. Try This: Filter the Data Select Row 1. Go to Data ->Sort and Filter. Click on Filter.   Keep going...   Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.3 Filter and Sort a Table: Filter Records

Data->Sort and Filter->Filter