The quickest way to filter in Excel

To add a filter in Excel, select any cell in your data table, then go to the Data tab at the top and click Filter. Excel will add dropdown arrows to the header row of your table. Click any dropdown arrow to show only the rows you want to see, hide rows that don't match, or sort from A to Z.

You do not need to select your entire table first — Excel figures out where your data starts and stops. If your data does not have a header row (the first row with column names), add one before filtering, or Excel may treat your first data row as headers.

Once you turn on filtering, those dropdown arrows stay visible until you turn filtering off. You can filter by one column, multiple columns at once, or use more advanced options like filtering by color or by a range of numbers.

Key Takeaways

  • Click any cell in your data, then go to Data > Filter to add dropdown arrows to your header row.
  • Click a dropdown arrow and uncheck the rows you want to hide, or use sort options to arrange data from A to Z or smallest to largest.
  • You can filter multiple columns at the same time — each filter works together to show only rows that match all your choices.
  • To remove a filter from one column without turning off filtering entirely, click the dropdown arrow and select Reset Filter.

How to filter by a single column

Click the dropdown arrow in the column you want to filter. A menu appears with a list of every unique value in that column. Uncheck the boxes next to any values you want to hide, then click OK. Excel will hide those rows immediately.

For example, if you have a column called "Region" with values like North, South, East, and West, you can uncheck "South" and "West" to show only North and East. The hidden rows are still there — they are just not visible until you reset the filter or change it.

To see all rows again, click the dropdown arrow for that column and click Reset Filter. This removes the filter from that column but keeps filtering on any other columns you have set up.

Filtering multiple columns at once

You can add filters to as many columns as you need, and they work together. If you filter Region to show only "North" and also filter Status to show only "Active", Excel displays only rows where Region is North and Status is Active.

Each dropdown arrow shows a small funnel icon once you have applied a filter to that column, so you can see at a glance which columns are filtered. To change a filter, click the dropdown arrow again and adjust your choices. To remove all filters at once, go to Data > Filter again to turn filtering off.

Sorting data with the filter dropdown

The filter dropdown menu includes sort options at the top. Click Sort A to Z to arrange that column alphabetically, or Sort Z to A to reverse it. For columns with numbers or dates, you see Sort Smallest to Largest or Sort Largest to Smallest instead.

When you sort through a filter dropdown, Excel rearranges your entire table so that the rows line up with your sort choice. For example, sorting a "Date" column from smallest to largest puts the oldest dates at the top. The sort applies to all columns together — you are not sorting one column in isolation.

Using search and advanced filter options

If your column has hundreds of values, typing in the search box at the top of the filter menu narrows down the list. Type part of a word and Excel shows only matching values. This is faster than scrolling through a long list.

For more control, click Filter by Color to hide or show rows based on cell color or font color. You can also click Standard Filter (or More Filters depending on your Excel version) to set up rules like "show only numbers greater than 100" or "show only dates after January 1, 2024". These options appear in a separate dialog where you build conditions using dropdown menus.

Turning off filtering

To remove all filters and the dropdown arrows, go to the Data tab and click Filter again. This toggles filtering off. All hidden rows reappear, and the dropdown arrows disappear from your header row.

If you want to keep the filter dropdowns visible but show all rows, click Data > Reset Filter instead. This clears all your filter choices but leaves the dropdown arrows in place so you can filter again without going through the setup step.

Common filtering mistakes and how to avoid them

The most common mistake is forgetting that you have filtering on. You might think rows are missing from your spreadsheet when they are actually just hidden. Look for the funnel icon on the Data tab or check whether your row numbers skip (for example, jumping from row 5 to row 8) — that is a sign filtering is active.

Another mistake is applying a filter to a column that does not have a header. If your first row is data instead of column names, Excel treats that row as a header and does not filter it. Add a proper header row at the top before turning on filtering, or manually select your data range first by clicking the top-left cell of your table, holding Shift, and clicking the bottom-right cell, then apply the filter.

Frequently Asked Questions

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

Yes. Click the dropdown arrow, uncheck all values except the ones you want to see, then click OK. For example, you can show only rows where Region is "North" or "South" by unchecking East and West. All other columns can have their own separate filters too.

What is the difference between filtering and sorting?

Filtering hides rows that do not match your choice — the hidden rows are still in your file. Sorting rearranges all rows in a new order based on one column. You can do both at the same time: filter to show only certain rows, then sort those visible rows by another column.

Do filters affect formulas or calculations in my spreadsheet?

Most formulas ignore hidden rows, but some functions like SUM or AVERAGE have special versions (SUBTOTAL, SUMIF) that work correctly with filtered data. If you are using basic formulas, check your results after filtering to make sure the math is still correct for what you are trying to do.

Can I save my filter settings so they open the same way next time?

Yes. Set up your filters the way you want them, then save your file. When you open the file again, the filters stay in place and the same rows remain hidden. If you want to share a file with specific filters already applied, save it with those filters active.

What if the filter dropdown arrow does not appear?

Make sure your first row contains headers (column names), not data. Click any cell in your table, go to Data > Filter, and try again. If you are using a very old version of Excel, the Filter button might be in a different location — check the Data menu or look for an icon that looks like a funnel.