What a filter does and when you need one

A filter in Excel lets you hide rows that don't match what you're looking for, so you see only the data you want. You're not deleting anything — the hidden rows are still there. When you filter a column for "New York", Excel hides every row from other states. When you remove the filter, those rows come back.

Filters are useful when your spreadsheet has hundreds or thousands of rows. Instead of scrolling through everything, you can show only sales from March, or only customers in one region, or only items that cost more than fifty dollars. You can filter by one column or by several at once.

The filter sits at the top of each column as a small dropdown arrow. You click the arrow, choose what to show, and Excel does the hiding for you.

Key Takeaways

  • Filters hide rows that don't match your choice — they don't delete data, and you can remove the filter anytime to see everything again.
  • You turn on filters by selecting your data and clicking the Filter button in the Data tab, which adds dropdown arrows to the top row.
  • Click any dropdown arrow to choose which values to show; you can filter by text, by number, or by date.
  • You can filter by multiple columns at once, and Excel will show only rows that match all your choices.
  • Sorting and filtering are different — sorting rearranges rows, while filtering hides them.

How to turn on filters for your data

Before you can filter, you need to tell Excel which rows contain your data. Click any cell inside your data — it doesn't matter which one. Then go to the Data tab at the top of the ribbon and click the Filter button. Excel will add a small dropdown arrow to the header row of each column.

If your data doesn't have a header row (a row of labels at the top), Excel will treat the first row of data as headers. If that's wrong, you can undo the filter, add a proper header row, and turn the filter back on. The header row tells Excel which column is which, so it needs to be there.

Once the arrows appear, your filter is ready to use. You don't have to do anything else to set it up.

Filtering by a single column

Click the dropdown arrow in the column you want to filter. A menu will open showing every unique value in that column — if your column is "State", you'll see Alabama, Alaska, Arizona, and so on. At the top of the menu is a search box and a list of checkboxes.

By default, all values are checked, meaning all rows are visible. To hide rows, uncheck the values you don't want to see. If you want to show only New York, uncheck everything except New York. If you want to hide just one state, uncheck that state and leave the rest checked. Then click OK at the bottom of the menu.

Excel will hide all rows that don't match your choice. The row numbers on the left will turn blue, which tells you a filter is active. The dropdown arrow in that column will also change color to show that a filter is applied.

Filtering by multiple columns at once

You can filter by more than one column. For example, you might want to show only sales from New York in March. Click the dropdown arrow in the State column, uncheck everything except New York, and click OK. Then click the dropdown arrow in the Month column, uncheck everything except March, and click OK.

Now Excel shows only rows where the state is New York AND the month is March. Every other row is hidden. If you want to add a third filter, click another column's dropdown arrow and make your choice. You can filter by as many columns as you need.

To remove one filter without removing the others, click its dropdown arrow and check "All" to show all values in that column again. To remove all filters at once, go to the Data tab and click Filter again — this turns off the filter feature entirely and shows all rows.

Filtering numbers and dates

When you filter a column of numbers or dates, the menu works the same way — you see a list of values and checkboxes. But you also get extra options. Click the dropdown arrow and look for a link that says Number Filters or Date Filters. This opens a submenu with choices like "Greater Than", "Less Than", "Between", and "Equals".

If you want to show only sales over one thousand dollars, click Number Filters and choose Greater Than. A dialog box will open asking you to enter a number. Type 1000 and click OK. Excel will hide all rows where the sales amount is one thousand or less.

For dates, you can filter by a specific date, a date range, or relative dates like "This Year" or "Last Month". The process is the same — click the dropdown arrow, choose Date Filters, pick the type of filter you want, and enter your criteria.

Sorting filtered data

After you filter your data, you can still sort it. Sorting rearranges the rows in order — alphabetical, smallest to largest, newest to oldest — while filtering hides rows. You can do both at the same time.

To sort filtered data, click the dropdown arrow in the column you want to sort by. At the top of the menu, you'll see sort options: Sort A to Z, Sort Z to A, Sort Smallest to Largest, or Sort Largest to Smallest, depending on the column type. Click the sort you want. Excel will rearrange the visible rows in that order, but the hidden rows stay hidden.

For example, you could filter to show only New York sales, then sort those sales from largest to smallest. You'd see only New York rows, arranged by sales amount. When you remove the filter, all rows come back in their original order.

Clearing filters and starting over

To remove a single filter and show all values in one column again, click its dropdown arrow and check the box next to All. This shows all rows for that column, but keeps any other filters active.

To remove all filters at once and see your entire spreadsheet again, go to the Data tab and click Filter. This turns off the filter feature — the dropdown arrows disappear and all hidden rows reappear. Your data is unchanged; you're just removing the filter interface.

If you want to keep the filter arrows but show all data, click the dropdown arrow in any filtered column and check All. Repeat for any other filtered columns. This removes the filters but leaves the dropdown arrows in place, so you can filter again without turning the feature back on.

Frequently Asked Questions

Can I filter text that contains a certain word?

Yes. Click the dropdown arrow and look for Text Filters. Choose Contains and type the word you're looking for. Excel will show only rows where that column contains that word anywhere in the text.

What if I filter and see no rows at all?

This means no rows match all your filter choices. Check your filters by clicking each dropdown arrow — you may have filtered out everything by mistake. Uncheck one filter at a time until rows reappear, then adjust your choices.

Do filters change my original data?

No. Filters only hide rows; they don't delete or move anything. When you remove the filter, all rows come back exactly as they were. Your spreadsheet is never changed by filtering.

Can I copy only the filtered rows to another sheet?

Yes. After you filter, select all the visible rows (including the header), copy them, and paste them into a new sheet. Excel will copy only the rows you see, not the hidden ones. The hidden rows stay in the original sheet.

Why does my filter show blank cells as an option?

Blank cells are treated as a value in Excel. If your column has empty cells, they'll appear as a checkbox option in the filter menu. Uncheck "Blanks" to hide rows with empty cells in that column.