How to Use Autofilter in Excel: Quick Guide

To use Autofilter in Excel, select your data range and go to the Data tab, then click Filter. This adds dropdown arrows to your column headers, letting you filter or sort data easily by selecting criteria.

Syntax

The Autofilter feature in Excel does not use a formula but is accessed via the ribbon or shortcut keys. The main steps are:

• Select your data range including headers.
• Go to the Data tab on the ribbon.
• Click the Filter button to add dropdown arrows to each header cell.

These dropdown arrows let you choose filter options like sorting, selecting specific values, or applying conditions.

excel

No formula syntax; use Excel ribbon: Data > Filter

Example

This example shows how to apply Autofilter to a simple table of sales data and filter to show only sales above 100.

excel

1. Select cells A1 to C6 containing headers and data:

| Product | Sales | Region |
|---------|-------|--------|
| Apples  | 120   | East   |
| Oranges | 90    | West   |
| Bananas | 150   | East   |
| Grapes  | 80    | South  |
| Pears   | 200   | West   |

2. Go to the Data tab and click Filter.
3. Click the dropdown arrow in the Sales column.
4. Choose Number Filters > Greater Than.
5. Enter 100 and click OK.

Only rows with Sales > 100 will show.

Output

| Product | Sales | Region |
|---------|-------|--------|
| Apples  | 120   | East   |
| Bananas | 150   | East   |
| Pears   | 200   | West   |

Common Pitfalls

Common mistakes when using Autofilter include:

• Not selecting the entire data range including headers before applying the filter, which can cause incomplete filtering.
• Having blank rows or columns inside the data range, which breaks the filter range.
• Trying to filter data without headers, which disables the dropdown arrows.
• Forgetting to clear filters, which hides data unintentionally.

Always ensure your data is in a continuous range with headers before applying Autofilter.

excel

Wrong way:
Select only data cells without headers and apply Filter.

Right way:
Select headers and all data cells, then apply Filter.

Quick Reference

Action	How to Do It
Apply Autofilter	Select data including headers > Data tab > Filter
Filter by value	Click dropdown arrow > check/uncheck values
Filter by condition	Dropdown arrow > Number/Text Filters > choose condition
Clear filter	Data tab > Clear
Remove Autofilter	Data tab > Filter (toggle off)

Key Takeaways

Select your entire data range including headers before applying Autofilter.

Use the Data tab's Filter button to add dropdown arrows for filtering.

Dropdown arrows let you filter by values or conditions easily.

Avoid blank rows or columns inside your data range to keep filtering smooth.

Clear filters when done to see all your data again.