Filtering shows and hides rows based on what you type, without deleting anything

A filter in Excel is a tool that hides rows you don't want to see right now. You tell Excel which values matter — say, only transactions from January, or only items marked "urgent" — and it collapses everything else out of view. The data stays in your file. You can remove the filter anytime and see all the rows again.

Filtering is different from sorting, which rearranges your rows. Filtering is also different from deleting, which removes rows permanently. When you filter, you're just choosing what's visible on your screen. This matters because you might filter to find one thing, then filter differently to find something else, without ever losing a row.

The most common filter is the AutoFilter, which adds dropdown buttons to your column headers. You click the button, check or uncheck the values you want to see, and Excel hides the rest. It takes about 30 seconds to set up.

Key Takeaways

  • AutoFilter adds dropdown buttons to your headers and is the fastest way to hide rows you don't need right now.
  • You can filter by text (like a person's name), by number (like amounts over $100), or by date (like entries from this month).
  • Filtering hides rows but does not delete them — remove the filter and all rows come back.
  • You can filter multiple columns at once, so you see only rows that match all your conditions.

How to turn on AutoFilter and filter a single column

Click any cell in your data table. Then go to the Data menu at the top and click AutoFilter. Excel adds a small dropdown arrow to the right of each column header. That arrow is your filter button.

Click the dropdown arrow in the column you want to filter. A list appears showing every unique value in that column — every name, every amount, every date. Uncheck the box next to any value 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. Excel hides all the rows where the month is not January.

The dropdown arrow turns blue when a filter is active on that column, so you can see at a glance which columns are filtered. To remove the filter on that column, click the arrow again and click Clear Filter.

Filtering by text, number, or date ranges

If your column has hundreds of values, unchecking them one by one is slow. Excel lets you set up a condition instead. Click the dropdown arrow and look for Text Filters, Number Filters, or Date Filters depending on what type of data is in that column.

For text, you can choose Contains to show only rows where the text includes a word you type. For example, filter a "Notes" column to show only rows containing "urgent". For numbers, you can choose Greater Than or Less Than to show only amounts above or below a threshold. For dates, you can choose Between to show only entries from a specific date range.

Click the condition you want, type your criteria, and click OK. Excel hides all rows that don't match. This is much faster than scrolling through a long list of checkboxes.

Filtering multiple columns at once

You can filter two, three, or more columns in the same table. Each filter narrows down what you see. For example, filter the "Month" column to show only January, then filter the "Status" column to show only "Completed" items. Now you see only rows that are both January and Completed.

Set up the first filter by clicking its dropdown arrow and choosing your values. Then click the dropdown arrow in the second column and choose your values there. Excel applies both filters at once. The dropdown arrows on both columns turn blue to show they're active.

You can add more filters the same way. Each one narrows the view further. If you filter too much and see no rows at all, one of your conditions is too strict — click a dropdown arrow and loosen that filter.

Removing filters and going back to see all rows

To remove a filter from one column, click its dropdown arrow and select Clear Filter. That column shows all its values again, but other filters stay active.

To remove all filters at once and see every row in your table, go to the Data menu and click AutoFilter again. This turns off the filter feature entirely and removes all the dropdown arrows from your headers. All rows reappear.

Turning off AutoFilter does not delete any data. Your table is exactly as it was before you started filtering. You can turn AutoFilter back on anytime.

What happens when you sort a filtered table

If you sort a column while a filter is active, Excel sorts only the rows you can see. The hidden rows stay hidden and don't move. This is useful if you filter to show only January transactions, then sort by amount to see your largest January transactions first.

When you remove the filter later, the hidden rows reappear in their original order, not in the sorted order. If you want to sort your entire table, remove all filters first, then sort.

Copying filtered data without the hidden rows

When you copy a filtered table, Excel copies only the visible rows — the hidden ones don't come along. This is helpful if you filter your data, then want to paste just the filtered results into a new sheet or a different file.

Select the cells you want to copy (or press Ctrl+A to select all visible cells), then copy as usual. When you paste, only the rows that were showing on your screen appear in the new location. The hidden rows stay in your original file, untouched.

Frequently Asked Questions

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

Yes. Click the dropdown arrow, and check only the values you want to see. For example, check "January" and "February" but uncheck the other months. Excel shows rows where the month is January or February. You can select as many values as you need.

What if I filter and see no rows at all?

Your filter conditions are too strict — no rows match all of them. Click one of the blue dropdown arrows and loosen the filter by adding back a value or changing the condition. For example, if you filtered for amounts greater than $1,000 and see nothing, try $500 instead.

Does filtering change my original data?

No. Filtering only hides rows temporarily. Your file is unchanged. When you remove the filter, all rows come back exactly as they were. You can filter and unfilter as many times as you want without affecting your data.

Can I save a file with filters turned on?

Yes. When you save your file, the filters stay in place. The next time you open the file, the same rows will be hidden. If you want to save the file with all rows visible, remove the filters before saving.