Filter multiple columns at once to narrow down your data
When you have a spreadsheet with many rows and columns, filtering lets you hide everything except the rows that match what you're looking for. Excel's AutoFilter feature lets you set conditions on more than one column at the same time — so you can show only the rows where the date is after January 1 and the status is "Complete" and the amount is over $500, for example. This is faster than scrolling through thousands of rows by hand.
The filter stays in place until you clear it, so you can work with just the data you need, copy it to another sheet, or print it. When you remove the filter, all your rows come back — nothing is deleted.
Key Takeaways
- Turn on AutoFilter by selecting any cell in your data and clicking the Filter button in the Data tab, which adds dropdown arrows to each column header.
- Click the dropdown arrow in a column header to choose which values to show or hide, then repeat for each column you want to filter.
- Use "Custom Filter" or "Number Filters" to set conditions like "greater than" or "contains", which is faster than manually unchecking hundreds of values.
- The filter hides rows but does not delete them — click the Filter button again to remove the filter and see all rows.
- Filtered data can be copied, printed, or moved to another sheet while the filter is active, and only the visible rows will be included.
Turn on AutoFilter for your data
Start by clicking any cell inside your data table — it does not 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 of every column in your table.
If you do not see the Data tab, you may be in a view that hides it. Click somewhere in your spreadsheet first to make sure you are in the normal editing view, not Page Layout or another mode. The Filter button looks like a funnel with lines next to it.
Once the dropdown arrows appear, your data is ready to filter. You have not hidden anything yet — the arrows are just controls you use to set up your filters.
Filter the first column by clicking its dropdown arrow
Click the dropdown arrow in the header of the first column you want to filter. A menu will open showing every unique value in that column. For example, if the column contains city names, you will see a list of all the cities in your data.
At the top of the menu are checkboxes next to each value. By default, all values are checked, meaning all rows are visible. Uncheck the values you want to hide. If you want to show only rows where the city is "Boston", uncheck every other city. When you click OK, Excel hides all rows that do not match your choice.
If your column has many values and you want to hide most of them, it is faster to click Uncheck All at the top of the menu, then check only the ones you want to see.
Add a filter to a second column without removing the first
Now click the dropdown arrow in the header of a second column. The menu shows only the values that are still visible after your first filter — Excel is already narrowing the list for you. Uncheck the values you do not want to see in this column.
When you click OK, Excel applies both filters at the same time. Now only rows that match both your first filter and your second filter are visible. The dropdown arrows in both columns will turn blue to show that a filter is active on them.
You can add filters to as many columns as you need. Each new filter works with all the previous ones, narrowing your data further.
Use Custom Filter for conditions like "greater than" or "contains"
If you want to filter by a condition instead of by specific values, use Custom Filter. Click the dropdown arrow in the column you want to filter, then look for Number Filters (if the column contains numbers), Text Filters (if it contains text), or Date Filters (if it contains dates). Click the arrow next to one of these options to see choices like "Greater Than", "Less Than", "Contains", or "Between".
For example, if you have a column of dollar amounts and want to show only rows where the amount is greater than $1,000, click Number Filters and then Greater Than. A dialog box will open where you type 1000. Click OK and Excel hides all rows with smaller amounts.
Custom filters are much faster than unchecking hundreds of individual values. They also work together with other filters — if you have already filtered one column, a custom filter on a second column will only explore to the rows that are still visible.
Clear a filter to see all rows again
To remove all filters at once and see every row, go to the Data tab and click Filter again. The dropdown arrows disappear and all hidden rows reappear. Your data is not changed — nothing was deleted, just hidden and now unhidden.
If you want to remove the filter from only one column while keeping filters on others, click the dropdown arrow in that column and select Clear Filter From [Column Name]. The rows hidden by that column's filter will reappear, but filters on other columns stay in place.
Copy or print only the filtered rows
When you have filtered your data down to what you need, you can copy only the visible rows to another sheet or document. Select the cells you want to copy (including headers if you want them), press Ctrl+C, then go to another sheet and press Ctrl+V. Excel copies only the visible rows, not the hidden ones.
The same is true for printing. If you print while a filter is active, Excel prints only the visible rows. This is useful when you want a report showing just one category or a specific date range without having to delete or reorganize your original data.
Frequently Asked Questions
Can I filter by more than two columns at once?
Yes. You can add filters to as many columns as you need. Each filter narrows the results further. For example, you could filter by city, then by date, then by status, and only rows matching all three conditions will be visible.
What if I filter a column and the dropdown arrow turns blue?
A blue arrow means that column has an active filter on it. The rows you see are already being filtered by that column's conditions. You can still add filters to other columns, and they will work together with the blue-arrow filter.
If I filter my data and then save the file, will the filter stay when I open it again?
Yes. Excel remembers which filters you set. When you open the file again, the same rows will be hidden. You can remove the filters by clicking the Filter button in the Data tab to see all rows again.
Does filtering delete any of my data?
No. Filtering only hides rows — it does not remove them. When you clear the filter, all rows come back unchanged. Your original data is always safe.
Can I filter text that contains a specific word?
Yes. Click the dropdown arrow in a text column, select Text Filters, then choose Contains. Type the word you are looking for, and Excel will show only rows where that column contains that word anywhere in the text.