Filtering lets you hide rows that don't match what you're looking for

Filtering a column in Excel means telling the spreadsheet to show only the rows where that column contains a value you care about. If you have a list of 500 transactions and want to see only the ones from January, you filter the date column to January. Excel hides the other rows temporarily — they're still there, just not visible. You can remove the filter anytime to see everything again.

The fastest way is to click any cell in the column you want to filter, then click the Data tab at the top of the screen and select AutoFilter. Excel adds a small dropdown arrow to the header of every column. Click the arrow in the column you want to filter, check or uncheck the values you want to see, and click OK.

Key Takeaways

  • Click a cell in your data, go to the Data tab, and click AutoFilter to add dropdown arrows to every column header.
  • Click the dropdown arrow in any column, uncheck the values you want to hide, and click OK to filter.
  • You can filter multiple columns at once — each filter works together to show only rows that match all of them.
  • Filtered data is hidden, not deleted; remove the filter by clicking Data > AutoFilter again to see all rows.
  • Use the search box in the filter menu to find a specific value quickly instead of scrolling through a long list.

Setting up AutoFilter on your spreadsheet

Before you can filter, you need to turn on AutoFilter. Click any cell that contains data — it doesn't matter which one. Then click the Data tab in the ribbon at the top of Excel. Look for the AutoFilter button and click it. Excel will add a small dropdown arrow to the right side of each column header in your data range.

If your data doesn't have a header row (a row at the top with column names), Excel will treat the first row of data as the header. It's usually better to add a real header row first — click the row above your data, right-click, and select Insert to add a blank row, then type column names like "Date", "Amount", or "Customer Name".

Filtering to show only the rows you want

Once AutoFilter is on, click the dropdown arrow in the column you want to filter. A menu appears with a list of every unique value in that column. By default, all values are checked, meaning all rows are visible. Uncheck the values you want to hide. For example, if the column shows months and you only want to see January, uncheck February, March, April, and so on. Then click OK at the bottom of the menu.

Excel now shows only the rows where that column contains a checked value. The row numbers on the left turn blue to show that some rows are hidden. The dropdown arrow in the filtered column also turns blue as a reminder that a filter is active there. You can scroll through the visible rows normally — the hidden ones stay hidden until you change the filter.

Filtering multiple columns at the same time

You can filter more than one column, and the filters work together. If you filter the date column to show only January and the status column to show only "Completed", Excel displays only rows that are both January AND Completed. Rows from January that aren't completed stay hidden, and completed rows from other months stay hidden too.

To add another filter, click the dropdown arrow in a different column and uncheck the values you don't want. Each column can have its own filter active. If you want to change or remove one filter without affecting the others, click its dropdown arrow again and adjust the checkboxes.

Finding a specific value in a long list

If a column has hundreds of different values, scrolling through the filter menu to find one item takes time. Instead, use the search box at the top of the filter menu. Click the dropdown arrow, then type in the search box — it usually says "Search" or has a magnifying glass icon. As you type, the list below shrinks to show only values that match what you typed. Type "Jan" and the list shows only values containing "Jan", like "January", "January 15", or "Janice".

Once you see the value you want, check only that box and click OK. This is much faster than unchecking dozens of items one by one.

Removing a filter to see all rows again

To turn off all filters and see every row in your spreadsheet, click the Data tab and click AutoFilter again. The dropdown arrows disappear from the headers, and all hidden rows reappear. The data itself doesn't change — filtering only hides rows temporarily.

If you want to keep AutoFilter on but remove the filter from just one column, click that column's dropdown arrow and select Clear Filter or All (depending on your Excel version). That column will show all its values again, but filters on other columns stay active.

What happens to filtered data when you copy or print

When you copy cells from a filtered spreadsheet, Excel copies only the visible rows — the hidden ones are not included. This is usually what you want. If you filter to show only January transactions and copy the visible data into a new spreadsheet, you get only January. The hidden rows stay in the original spreadsheet but don't get copied.

Printing works the same way. If you print a filtered spreadsheet, only the visible rows print. Make sure your filter is set correctly before you print, or you might print only a portion of your data by accident.

Frequently Asked Questions

Can I filter by a range of numbers instead of picking individual values?

Yes. Click the dropdown arrow in a number column and select Number Filters or Standard Filter (the exact name varies by Excel version). You can then choose options like "greater than", "less than", or "between" and enter the numbers you want. For example, you can filter to show only amounts greater than $1,000.

What if I filter a column and then add new data below — does the new data get filtered too?

New rows added below your filtered data won't automatically be included in the filter range. If you add many new rows regularly, it's better to convert your data to a table first. Click a cell in your data, go to the Home tab, click Format as Table, and choose a style. Tables automatically expand to include new rows, and filters adjust accordingly.

Can I save a spreadsheet with filters on so they stay filtered when I open it again?

Yes. When you save an Excel file with active filters, the filters are saved with it. When you open the file again, the same filters are still active and the same rows are hidden. If you want to remove the filters before saving, turn off AutoFilter first, then save.

How do I filter to show only blank cells or only cells with data?

Click the dropdown arrow in the column. At the top of the filter menu, you'll see options like Blanks or Non-blanks (exact wording varies). Check only the option you want — for example, check Blanks to show only empty cells in that column, then click OK.