The Basics Calculations Special Features
Format Cells Statistical Functions The Fill Handle
Worksheets Quick Functions Charts (Graphs)
Edit Cells The IF Function Sort Data
Rows and Columns VLOOKUP Function Filter Data
Find and Replace Formulas First Aid
Home
Word Training
Updates
About
Guestbook
Links

Working with the "Filter" utility

Basic filtering
Filtering by numerical values
Filtering by texts
Filtering by dates
More examples of using Excel's filtering

When should you use the “Filter” utility?

Whenever you have a big table, from which you want to show only curtain 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, phone number, home address, expected wage and of course - profession.

By using the “Filter” utility you can quickly bring up from your table and show:
All the job seekers that live in New Jersey.
All the seekers who are female.
All the seekers with the profession defined as: model.
All the Female models who live in New Jersey.
All the Female models who are single and live in New Jersey and are under the age of 24.
The lawyer with the lowest “expected wage” in New Jersey.