Click the filter button to turn on filtering for your data

To add a filter to a column in Excel, first select any cell in the table you want to filter. Then go to the Data tab at the top of the screen and click Filter. Excel will automatically add dropdown arrows to the header row of your table — one arrow per column.

These dropdown arrows let you show only the rows that match what you're looking for. You don't need to select the entire table first; Excel figures out where your data starts and stops based on the cell you clicked.

If your table doesn't have a header row yet, Excel will treat the first row of data as headers. If that's wrong, click Data, then Filter again to turn filtering off, add a proper header row at the top, and turn filtering back on.

Key Takeaways

  • Click any cell in your table, go to the Data tab, and click Filter to add dropdown arrows to your column headers.
  • Click a dropdown arrow to show only rows that match a specific value, date range, or text pattern.
  • You can filter multiple columns at once — Excel shows only rows that match all your filters together.
  • Click the dropdown arrow again and select "Clear Filter" to show all rows in that column again.
  • Filtering hides rows but doesn't delete them; turning off the filter shows everything again.

Click the dropdown arrow to choose what to show

Once filtering is on, click the dropdown arrow in any column header. A menu appears with a list of every unique value in that column — names, dates, numbers, whatever is there. Each item has a checkbox next to it.

By default, all checkboxes are checked, meaning all rows are visible. To hide rows, uncheck the values you don't want to see. For example, if a column contains city names and you uncheck "Denver" and "Phoenix", Excel will hide every row where that column says Denver or Phoenix. The other cities stay visible.

Click OK at the bottom of the menu to explore the filter. The dropdown arrow turns blue to show that a filter is active on that column. Any rows that don't match your choices disappear from view.

Use search and number filters for faster sorting

If a column has hundreds of values, scrolling through checkboxes takes time. Instead, type in the search box at the top of the filter menu. Excel narrows the list to only items that contain what you typed. For example, typing "Smith" in a name column shows only names with Smith in them.

For columns with numbers or dates, the filter menu offers extra options. Click Number Filters or Date Filters (the exact label depends on what's in the column). You can then choose conditions like "greater than", "between", "before", or "after". This is faster than unchecking individual values when you want to show only numbers above 500 or dates in the last month.

Filter multiple columns to narrow down your results

You can filter more than one column at the same time. Click the dropdown arrow in a second column and choose what to show there too. Excel displays only rows that match all your filters together.

For example, if you filter a "City" column to show only "Seattle" and a "Status" column to show only "Active", Excel shows only rows where the city is Seattle and the status is Active. Rows that are Active but in a different city, or Seattle but not Active, stay hidden.

Each filtered column shows a blue dropdown arrow. You can see at a glance which columns have filters on them.

Clear a filter to show all rows again

To remove a filter from one column, click its dropdown arrow and select Clear Filter From [Column Name]. All rows in that column become visible again, though any other filters you set stay in place.

To remove all filters at once and show every row, go to the Data tab and click Filter again. This turns off filtering entirely and removes the dropdown arrows from your headers.

Clearing a filter doesn't change your data — it just shows rows that were hidden. Your original spreadsheet is exactly the same.

Filtering works with sorted data too

You can sort and filter at the same time. For example, filter a "Date" column to show only entries from this year, then sort that filtered data from newest to oldest. Excel sorts only the visible rows, leaving hidden rows in their original order.

If you remove the filter later, the sort stays in place — all rows go back to being visible, but they're still in the sorted order you chose.

Frequently Asked Questions

Can I filter text that contains a specific word?

Yes. Click the dropdown arrow, type the word in the search box at the top, and Excel shows only values that contain that word. For example, searching "urgent" in a notes column shows all rows with urgent anywhere in the text. Then uncheck any you don't want and click OK.

What if I filter a column and then add new data below?

The filter applies only to data that existed when you turned it on. New rows added below won't be included in the filter. Click any cell in the new data, go to Data, click Filter to turn it off, then turn it back on. Excel will recognize the larger table and add the new rows to the filter.

Can I filter by color or formatting?

Yes, if your cells are colored or formatted differently. Click the dropdown arrow, then look for "Filter by Color" or "Filter by Font Color" depending on your version of Excel. You can then choose which colors to show or hide.

Does filtering change my original data?

No. Filtering only hides rows; it doesn't delete or move anything. When you clear the filter, all rows come back exactly as they were. Your data is safe.

Can I copy only the filtered rows?

Yes. After filtering, select the visible rows you want to copy, press Ctrl+C (or Cmd+C on Mac), and paste them elsewhere. Excel copies only the visible cells, not the hidden ones.