The fastest way to filter in Excel
To filter data in Excel, select any cell in your data range, then click the Data tab at the top and choose AutoFilter. Excel will add dropdown arrows to the header row of your data. Click any dropdown arrow to show only the rows that match what you're looking for — uncheck the items you want to hide, then click OK.
This works on any table of data with headers. If your data doesn't have a header row, Excel will treat the first row as headers when you turn on AutoFilter, so add one first if you need to.
Filtering doesn't delete or move your data — it just hides rows that don't match your choices. When you clear the filter, all rows come back.
Key Takeaways
- Click any cell in your data, go to the Data tab, and select AutoFilter to add dropdown arrows to your headers.
- Click a dropdown arrow, uncheck the items you want to hide, and click OK to show only matching rows.
- You can filter by text, numbers, dates, or custom conditions like "greater than 100" or "contains the word urgent".
- Filtering hides rows but does not delete them — clear the filter to see everything again.
- Use the small funnel icon in the column header to see which columns are currently filtered.
Filtering by text or numbers
When you click a dropdown arrow in a text or number column, you see a list of every unique value in that column. Uncheck the box next to any value you want to hide. For example, if a column lists cities and you only want to see rows for "New York", uncheck every other city.
At the top of the dropdown, a search box lets you type to find values faster. Type "New" and the list shrinks to show only items containing "New". This is useful when a column has hundreds of different entries.
If you want to hide just a few values instead of showing just a few, uncheck All first (which unchecks everything), then check only the ones you want to see. Click OK when you're done.
Filtering by date or custom conditions
Date columns have a special filter option. Click the dropdown arrow in a date column and you'll see Date Filters at the top of the menu. Click it to choose options like "This Year", "Last Month", or "Between" two dates you specify. This is faster than unchecking individual dates.
For number columns, click Number Filters to set conditions like "Greater Than 500" or "Does Not Equal 0". You can also use Standard Filter (at the bottom of most filter menus) to build more complex rules — for example, show rows where the price is greater than 100 AND the status is "In Stock".
To remove a filter from one column, click its dropdown arrow and select Clear Filter From [Column Name]. To remove all filters at once, go to the Data tab and click AutoFilter again — this turns off filtering entirely.
Filtering multiple columns at once
You can filter on more than one column. Set up the first filter, then click the dropdown in a second column and set another filter. Excel shows only rows that match both conditions. A small funnel icon appears in the header of any column that is currently filtered, so you can see at a glance which columns have active filters.
For example, if you have a sales list with columns for Region, Product, and Amount, you could filter Region to show only "West" and Amount to show only values greater than 5000. The result shows only Western sales over 5000.
Each filter works independently. If you change your mind about one filter, click its dropdown and adjust it without affecting the others.
When filtering isn't enough: sorting alongside filters
Filtering hides rows, but sometimes you also want to arrange what's left in a specific order. You can sort and filter together. Set up your filter first, then click the Data tab and choose Sort. Excel sorts only the visible (filtered) rows, leaving hidden rows in their original order. When you clear the filter later, the hidden rows stay where they were.
You can also sort directly from a column's dropdown arrow. Click the arrow and choose Sort A to Z or Sort Z to A for text, or Sort Smallest to Largest for numbers. This sorts the entire dataset, not just filtered rows.
Copying filtered data without the hidden rows
When you copy data that has a filter applied, Excel copies only the visible rows — the hidden ones stay hidden and don't get copied. This is useful when you want to paste filtered results into a new sheet or document.
Select the filtered data (or press Ctrl+A to select all visible data), copy it with Ctrl+C, then paste it where you need it. The hidden rows won't appear in the paste. If you want to include hidden rows in your copy, clear the filter first, then copy.
Frequently Asked Questions
Can I filter by color or formatting?
Yes. Click a column's dropdown arrow and look for Filter by Color near the bottom of the menu. You can show only cells with a specific background color or font color. This works if you've manually colored cells or used conditional formatting rules.
What's the difference between AutoFilter and Standard Filter?
AutoFilter is the simple dropdown method — you uncheck items you don't want to see. Standard Filter (found in the Data menu under Filter) lets you build complex rules with multiple conditions and operators like AND and OR. Use AutoFilter for quick, simple filtering and Standard Filter when you need more control.
If I filter data, does it change the original file?
No. Filtering only hides rows — it doesn't delete, move, or modify anything. When you save the file, the filter settings are saved with it, so the same rows will be hidden when you open it again. To reset, clear the filter or turn off AutoFilter.
Can I filter a column that has blank cells?
Yes. When you click a column's dropdown, blank cells appear as an option in the list. You can uncheck the blank option to hide empty rows, or uncheck everything else to show only rows with blank cells in that column.
What if my data doesn't have headers?
Excel will treat your first row as headers when you turn on AutoFilter. If your first row is actually data, add a header row above it first. Click the first row, right-click, and choose Insert to add a blank row, then type your column names.