Filtering shows you only the rows that match what you're looking for

Filtering in Excel hides the rows you don't need and displays only the ones that meet your criteria. You keep all your data in the spreadsheet — nothing is deleted — but you see a smaller, focused view. When you remove the filter, all rows reappear. This is different from sorting, which rearranges your data permanently.

The most common type is AutoFilter, which adds dropdown arrows to your column headers. You click the arrow, choose which values to show, and Excel hides everything else. It takes about 30 seconds to set up and works on any data table with headers.

Filtering is useful when you have a spreadsheet with hundreds of rows and you need to focus on a subset — for example, showing only invoices from one vendor, or only sales above a certain amount, or only entries from the last month. You can filter by one column, multiple columns at once, or use more complex rules.

Key Takeaways

  • AutoFilter adds dropdown arrows to your headers and is the fastest way to show only rows matching your choice.
  • You can filter on multiple columns at the same time, and each filter narrows the view further.
  • Filtering hides rows but does not delete them — removing the filter brings everything back.
  • Standard filters work on exact matches or straightforward comparisons; advanced filters let you use formulas or multiple conditions on the same column.

How to turn on AutoFilter and filter a single column

Click any cell in your data table. Go to the Data tab at the top of the ribbon. Click Filter (or AutoFilter depending on your Excel version). Dropdown arrows now appear in the header row of every column.

Click the dropdown arrow in the column you want to filter. A menu appears showing every unique value in that column, each with a checkbox. Uncheck the values you want to hide. For example, if the column contains vendor names and you uncheck "Vendor B" and "Vendor C", only rows with "Vendor A" will show. Click OK when you're done.

The hidden rows are still in your spreadsheet. The row numbers on the left side turn blue, and some numbers are missing — that's how you know rows are hidden, not deleted. To show all rows again, click the dropdown arrow in that column and select All, or go to the Data tab and click Clear Filter.

Filtering on multiple columns at once

You can filter on as many columns as you need. Each filter narrows the view further. For example, you might filter the "Region" column to show only "West", then filter the "Status" column to show only "Completed". Now you see only completed sales in the West region.

The dropdown arrows in filtered columns turn blue to remind you a filter is active. If you forget which columns are filtered, look for the blue arrows. To remove one filter and see all values in that column again, click its dropdown and select All. The other filters stay in place.

If you want to clear all filters at once and see your entire table, go to the Data tab and click Clear Filter (or Reset Filter). This removes every filter you've set.

Using comparison filters for numbers and dates

The basic dropdown menu works for exact matches — you pick "Vendor A" or "Vendor B". For numbers and dates, you often want to use comparisons instead: show me sales greater than $5,000, or dates after January 1, or amounts between $100 and $500.

Click the dropdown arrow in the column you want to filter. Look for an option called Number Filters (for numbers) or Date Filters (for dates). A submenu appears with options like "Greater Than", "Less Than", "Between", and "Equals". Click the one you need.

A dialog box opens where you enter the value or values you're comparing to. For "Greater Than", you type the number once. For "Between", you type a low value and a high value. Click OK and Excel shows only rows that match your rule. For example, filtering for dates "After" January 1, 2024 will hide all rows with earlier dates.

Using Standard Filter for complex rules on one column

Sometimes you need more control than the basic dropdown gives you. The Standard Filter dialog lets you combine multiple conditions on the same column using "AND" or "OR" logic. For example, you might want to show rows where the amount is greater than $1,000 AND less than $5,000 — a range with both a floor and a ceiling.

Go to the Data tab and click Filter, then Standard Filter (the exact name varies by Excel version; look for "More Filters" or "Advanced"). A dialog opens with rows for conditions. The first row is already filled in with your column name. Choose your comparison operator from the middle dropdown — "Greater Than", "Less Than", "Equals", and so on. Enter the value on the right.

To add a second condition on the same column, click the second row. In the leftmost dropdown, select your column name again. Choose your operator and value. In the middle column of that row, select AND if both conditions must be true, or OR if either one can be true. Click OK. Your table now shows only rows matching both rules.

Filtering text with wildcards and partial matches

If you want to find all entries that contain a certain word or phrase — not an exact match, but a partial one — use a wildcard. The asterisk (*) stands for any number of characters. For example, typing "Smith*" finds "Smith", "Smithson", and "Smith-Jones". Typing "*Smith" finds "Smith", "Goldsmith", and "John Smith".

Open the Standard Filter dialog (Data tab, then Filter, then Standard Filter). In the column you want to search, choose "Contains" or "Begins With" from the operator dropdown, or use "Equals" with a wildcard. Type your search term with the asterisk in the right place. Click OK. Excel shows only rows where the column text matches your pattern.

This is useful when you have messy data — names spelled slightly differently, product codes with prefixes, or addresses with varying formats. Instead of filtering for each variation separately, one wildcard filter catches them all at once.

Removing filters and going back to your full table

To remove a single filter and show all values in one column again, click its dropdown arrow and select All. The other filters stay active.

To remove all filters at once and see your entire table, go to the Data tab. Click Clear Filter or Reset Filter (the exact name depends on your Excel version). All hidden rows reappear, and the dropdown arrows stay in the header row in case you want to filter again.

To turn off AutoFilter completely and remove the dropdown arrows, go to the Data tab and click Filter again. The arrows disappear, but your data is unchanged.

Frequently Asked Questions

Does filtering delete my data?

No. Filtering only hides rows — it does not delete anything. When you remove the filter, all rows come back exactly as they were. Your original data is always safe.

Can I filter on text that appears anywhere in a cell, not just at the start?

Yes. Use the Standard Filter dialog and choose "Contains" from the operator dropdown, then type the text you're looking for. Excel will show rows where that text appears anywhere in the column, whether at the beginning, middle, or end.

What's the difference between filtering and sorting?

Filtering hides rows you don't want to see; sorting rearranges all rows in a new order (A to Z, smallest to largest, oldest to newest). You can do both on the same table — filter first to show only the rows you care about, then sort those rows by a different column.

Can I filter by more than one value in the same column?

Yes. Click the dropdown arrow in the column, and uncheck only the values you want to hide. Leave checked all the values you want to see. For example, if a column has "North", "South", "East", and "West", you can uncheck "East" and "West" to show only North and South regions.

What if I filter one column and then want to filter another?

Just click the dropdown arrow in the second column and set up your filter. The first filter stays active. Now you see only rows that match both filters. You can filter as many columns as you need — each one narrows the view further.