Data filtering (Data Filter) in Excel
The following article gives detailed instructions for you to filter data in Excel.
Data filtering (Data Filter) in Excel Picture 1
1. Simple data filtering 1 condition.
Step 1: Select the data you want to filter -> Data -> Filter -> data column appears arrow containing the options:
Data filtering (Data Filter) in Excel Picture 2
Step 2: If you want to filter by a certain value, do the following: Uncheck Select All and select the value to be filtered, for example, here filter the employees born in 1987 -> OK:
Data filtering (Data Filter) in Excel Picture 3
- Data of employees with 1987 birth year are displayed:
Data filtering (Data Filter) in Excel Picture 4
- If you want to display all data -> click the arrow -> select Select All -> OK:
Data filtering (Data Filter) in Excel Picture 5
- After clicking OK the results:
Data filtering (Data Filter) in Excel Picture 6
2. Filter data by multiple conditions.
For example, want to filter employees with sales greater than or equal to 43915000 and greater than 74810000.
Step 1: Click the arrow -> drop down box -> click Custom Filter .
Data filtering (Data Filter) in Excel Picture 7
Step 2: The Auto Fillter dialog box appears, enter the values as shown -> OK:
Data filtering (Data Filter) in Excel Picture 8
- In case you want to display all data -> click the arrow -> click Select All:
Data filtering (Data Filter) in Excel Picture 9
The above is a detailed guide on how to filter data in Excel 2013.
Good luck!
You should read it
- MS Excel 2007 - Lesson 8: Sort and Filter
- Advanced data filtering in Excel
- How to use Advanced Filter to filter data on Excel
- How to remove duplicates in excel
- Filter data in Excel with Advanced Filter
- How to fix the error of Filter not filtering all the data?
- How to filter data in Excel
- How to filter duplicate data on 2 Excel sheets
- Filter data that doesn't overlap in Excel - Filter for unique values in Excel
- Guide to Automatic Filter and Filter detailed data in excel
- Filter duplicate data, delete duplicate data in Excel
- How to use Filter function on Google Sheets