Filters let you show only the rows that match what you're looking for

A filter in Excel hides rows that don't meet your criteria, so you see only the data you need. If you have a spreadsheet with 500 customer records and you want to see only those from California, a filter does that in seconds. Filters don't delete anything — they just hide rows temporarily. You can remove the filter anytime to see all your data again.

The most common type is the AutoFilter, which adds dropdown arrows to your column headers. You click the arrow, choose what to show, and Excel hides the rest. This works on any data range, from a simple list of names to a complex table with dozens of columns.

Key Takeaways

  • AutoFilter adds dropdown arrows to your headers and is the fastest way to hide rows that don't match your criteria.
  • Select any cell in your data range, then go to the Data tab and click AutoFilter to turn it on.
  • Click a column's dropdown arrow to choose which values to show, hide, or sort by.
  • You can filter by text, numbers, dates, or custom rules, and combine multiple filters at once.
  • Filtered data still prints and copies normally, but only the visible rows are included.

Turn on AutoFilter in three steps

Click any cell inside your data range — it doesn't matter which one. Then go to the Data tab at the top of the ribbon. Click the AutoFilter button. Excel adds a dropdown arrow to the header row of each column.

If you don't see a header row, Excel treats the first row of your selection as headers anyway. If your data doesn't have headers, add them before turning on AutoFilter — a header row makes filtering much clearer. Once AutoFilter is on, those dropdown arrows stay visible until you turn it off by clicking AutoFilter again.

Filter by clicking the dropdown arrow and choosing values

Click the dropdown arrow in any column header. A menu appears with a list of every unique value in that column. Uncheck the box next to any value you want to hide. For example, if the column shows states and you uncheck "Texas" and "Florida", only rows with other states will show. Click OK when you're done.

At the top of the menu, you'll see Search — type a few letters to find a specific value quickly instead of scrolling through a long list. You can also use Select All to uncheck everything at once, then check only the values you want to see. This is faster than unchecking dozens of items one by one.

Sort your data while filtering

The dropdown menu also has sort options at the top. Click Sort A to Z to arrange text alphabetically, or Sort Z to A to reverse it. For numbers and dates, you'll see Sort Smallest to Largest or Sort Largest to Smallest. Sorting happens instantly and doesn't affect your filter — hidden rows stay hidden.

You can sort by one column, then filter by another. For example, sort a sales column from highest to lowest, then filter to show only rows from January. The sort and filter work together.

Use number and date filters for ranges

For columns with numbers or dates, the dropdown menu includes a Number Filters or Date Filters option. Click it to see choices like "Greater Than", "Less Than", "Between", or "This Month". These let you set a range instead of picking individual values.

For example, click Date Filters in a date column, then choose Between. Enter a start date and end date, and Excel shows only rows within that range. This is much faster than manually unchecking dozens of dates. Number filters work the same way — you can show only sales over $1,000 or costs under $50 without listing every value.

Filter by multiple columns at once

Click the dropdown arrow in a second column and choose your criteria. The filter combines with your first filter — Excel shows only rows that match both conditions. For example, filter the State column to show only California, then filter the Product column to show only "Widget A". Now you see only California rows that sold Widget A.

You can add filters to as many columns as you need. Each new filter narrows the results further. To remove a single filter, click its dropdown arrow and select Clear Filter. To remove all filters at once, go to the Data tab and click AutoFilter again — this turns off the feature entirely and shows all rows.

Copy and print filtered data

When you copy filtered data, Excel copies only the visible rows — the hidden ones stay hidden. This is useful when you want to send someone a subset of your data. Select the cells you want to copy, press Ctrl+C (or Cmd+C on Mac), and paste normally. Only what you see will paste.

Printing works the same way. If you have a filter on and you print, only the visible rows print. This prevents accidental printing of data you filtered out. If you want to print everything, remove the filter first by clicking AutoFilter again.

Frequently Asked Questions

Can I filter text that contains specific words?

Yes. Click the dropdown arrow, then click Text Filters and choose Contains. Type the word or phrase you're looking for, and Excel shows only rows where that column contains those letters. For example, filter a Name column to show only names containing "Smith".

What's the difference between AutoFilter and Advanced Filter?

AutoFilter is simpler and covers most everyday filtering needs — you click dropdowns and choose what to show. Advanced Filter is for complex criteria that AutoFilter can't handle, like "show rows where column A is greater than 100 AND column B contains 'urgent'". Most users never need Advanced Filter.

If I filter my data, does it change the original spreadsheet?

No. Filtering only hides rows; it doesn't delete or move anything. Remove the filter anytime to see all your data exactly as it was. The only permanent change is if you manually delete rows while a filter is on — those rows are gone even after you remove the filter.

Can I save a spreadsheet with filters turned on?

Yes. When you save, Excel remembers which filters you set. The next time you open the file, the filters are still there and still active. If you want to save the file without filters, turn off AutoFilter before saving.

What if I filter and then add new data to the spreadsheet?

New rows you add below your filtered data won't automatically be included in the filter. To include them, turn off AutoFilter and turn it back on. This resets the filter to include all rows, including the new ones.