You are learning Sorting and Filtering in MS Excel
How to filter data by text, numbers, or dates in Excel?
Here's how to filter data by text, numbers, or dates in Excel:
1. Select your data range: Make sure you highlight the entire table or area containing the data you want to filter.
2. Activate the Filter function: Go to the "Data" tab on the Excel ribbon. In the "Data Tools" group, click "Filter." This will add filter dropdown arrows to the header row of your data.
3. Choose the column to filter: Click the dropdown arrow on the header of the column you want to filter.
4. Filter by Text:
- Select "Text Filters" from the dropdown menu.
- Choose from various options like "Contains," "Does Not Contain," "Begins With," "Ends With," etc.
- In the text box, enter the specific text you want to filter by.
5. Filter by Numbers:
- Select "Number Filters" from the dropdown menu.
- Choose from options like "Equals," "Does Not Equal," "Greater Than," "Less Than," "Between," etc.
- Enter the desired number(s) in the provided text boxes.
6. Filter by Dates:
- Select "Date Filters" from the dropdown menu.
- Choose from options like "Equals," "Does Not Equal," "Before," "After," "Between," etc.
- Select the specific dates using the calendar pop-up or enter them manually.
7. Apply the filter:
- Click "OK" to apply the chosen filter criteria.
- Only rows matching your filter criteria will be displayed, while others are hidden.
8. Additional options:
- You can combine multiple filter criteria from different columns for more granular filtering.
- Use the filter dropdown menu to clear filters and return to the original data view.
By following these steps, you can effectively filter your data based on text, numbers, or dates in Excel.