Data filtering (Data Filter) in Excel
The following article gives detailed instructions for you to filter data in Excel.
1. Simple data filtering 1 condition.
Step 1: Select the data you want to filter -> Data -> Filter -> data column appears arrow containing the options:
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 of employees with 1987 birth year are displayed:
- If you want to display all data -> click the arrow -> select Select All -> OK:
- After clicking OK the results:
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 .
Step 2: The Auto Fillter dialog box appears, enter the values as shown -> OK:
- In case you want to display all data -> click the arrow -> click Select All:
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
Maybe you are interested
6 Data Collecting Apps You Need to Delete for Better Privacy
How to master numerical data in Google Sheets with the AVERAGE function
How to delete white space in a table in Word - Appears right below the data
Detected a new data theft campaign targeting AnyDesk users
How to update Excel PivotTable data
Detection of malicious code infecting the web browsers of 300,000 PCs, silently stealing user data