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...

 

Data->Sort and Filter->Filter

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.1. Filter data