Working with the "Filter" utility in Excel

Learn how to filter your data in Excel - extracting specific rows from your content, and hiding the others. You'll see how to filter by texts, numerical values and dates. Easy Examples and free spreadsheets are included.

When should you use the “Filter” utility?

Whenever you have a big table, from which you want to show only certain rows that fulfill some criteria.

For example, in an employment agency you have a big table of job seeker’s personal details.
The details could be: First and last name, age, gender, marital status, academic degree, phone number, home address, expected wage and of course - profession.

By using the “Filter” utility you can quickly bring up from your table of data and show:
All the job seekers who live in New Jersey.
All the seekers with the profession defined as: teacher.
All the teachers who live in New Jersey.
All the teachers who live in New Jersey and have a bachelor's degree.
And of course many more such combinations...