Filtering data with AutoFilter in Excel - Step-by-Step Guide

Introduction

AutoFilter helps you quickly show only the rows you want in a table. It hides the rows that do not match your criteria, making it easier to focus on specific data.

When you want to see sales only from a certain region in your sales report.

When you need to find all orders placed on a specific date in your order list.

When you want to display only employees from a particular department in your staff list.

When you want to check products that are out of stock in your inventory.

When you want to review customers who made purchases above a certain amount.

Steps

Step 1: Click

- any cell inside your data table

Excel recognizes the data range for filtering

Step 2: Go to

- Data tab on the Ribbon

Data tools and options appear

Step 3: Click

- Filter button in the Sort & Filter group

Small dropdown arrows appear in the header cells of your table columns

Step 4: Click

- dropdown arrow in the column header you want to filter

A menu with filter options appears

Step 5: Select

- the checkboxes or filter options you want (for example, select only one region)

Only rows matching your selection remain visible; others are hidden

Step 6: Click

- OK button in the filter menu

Filter is applied and the table shows only the filtered rows

Before vs After

Before

Table shows 100 rows with sales data from all regions: North, South, East, West

After

Table shows 25 rows with sales data only from the East region

Settings Reference

Filter dropdown arrows

📍 Data tab > Sort & Filter group > Filter button

Turn filter arrows on or off for the selected data range

Default: Off

Text Filters

📍 Filter dropdown menu in a text column

Filter text columns by specific text conditions

Default: None

Number Filters

📍 Filter dropdown menu in a number column

Filter number columns by numeric conditions

Default: None

Date Filters

📍 Filter dropdown menu in a date column

Filter date columns by date ranges or specific dates

Default: None

Common Mistakes

Clicking Filter button without selecting a cell inside the data range

Excel may not detect the correct data range to apply filters

Always click a cell inside your data table before turning on AutoFilter

Trying to filter a column without headers

Filter dropdown arrows appear only in header cells; without headers, filtering is confusing

Make sure your data has a header row before applying AutoFilter

Selecting filter options but forgetting to click OK

Filter changes do not apply until you confirm by clicking OK

Always click OK after choosing filter criteria to apply the filter

Summary

AutoFilter lets you quickly hide rows that don't match your chosen criteria.

You turn on AutoFilter from the Data tab by clicking the Filter button.

Use the dropdown arrows in column headers to pick what data to show.

Remember to select a cell inside your data and have headers before filtering.