How to Filter Data in Excel: Simple Steps to Use Filters

To filter data in Excel, select your data range and click the Filter button on the Data tab. Then use the dropdown arrows in the column headers to choose criteria and display only the rows that match your filter.

Syntax

Excel filtering is done through the user interface, not by typing formulas. The main steps are:

• Select your data range: Highlight the cells you want to filter.
• Enable Filter: Go to the Data tab and click Filter. This adds dropdown arrows to each column header.
• Apply Filter: Click the dropdown arrow on a column header, then select or search for the values you want to show.

This process hides rows that don’t match your criteria, making it easier to focus on specific data.

excel

1. Select your data range (e.g., A1:D20)
2. Click Data tab > Filter
3. Click dropdown arrow in column header
4. Choose filter criteria (e.g., select only "Completed" tasks)
5. Excel shows only rows matching criteria

Example

This example shows how to filter a list of tasks to display only those marked as "Completed".

plaintext

Task	Status
Task 1	Completed
Task 2	In Progress
Task 3	Completed
Task 4	Not Started

Steps:
1. Select A1:B5
2. Click Data > Filter
3. Click dropdown arrow in "Status" column
4. Check only "Completed"

Result:
Only rows with "Completed" status are visible.

Output

Task	Status
Task 1	Completed
Task 3	Completed

Common Pitfalls

• Not selecting the full data range: If you don’t select all columns or rows, the filter may not work correctly.
• Headers missing or not recognized: Make sure your data has clear headers in the first row; otherwise, Excel may treat headers as data.
• Filters applied but no visible change: Sometimes filters are active but no rows match the criteria, so it looks empty.
• Clearing filters: Remember to clear filters to see all data again by clicking Clear in the Filter menu or turning off Filter.

plaintext

Wrong:
- Selecting only part of the data range before applying filter

Right:
- Select entire data range including headers before clicking Filter

Quick Reference

Action	How to Do It
Select data range	Click and drag to highlight all data including headers
Enable filter	Go to Data tab and click Filter button
Apply filter	Click dropdown arrow in column header and choose criteria
Clear filter	Click Filter dropdown and select Clear Filter from
Remove filter	Click Filter button again to turn off filtering

Key Takeaways

Always select your entire data range including headers before applying a filter.

Use the Data tab’s Filter button to add dropdowns for easy filtering.

Click column dropdown arrows to pick which values to show or hide.

Clear filters to see all your data again when needed.

Filters hide rows that don’t match criteria but don’t delete data.