Last updated July 2026. To filter data in Excel, click any cell in your list, go to the Data tab, and choose Filter. A small arrow appears on every column header. Click an arrow to check or uncheck values, type in the search box, or open Number Filters or Text Filters to set a condition like greater than or contains. Excel then hides every row that does not match and leaves only the ones you want. Filtering is how you take a long converted list and look at just one vendor, one month, or every amount over a threshold without deleting anything.
When a PDF statement or report lands in Excel, you usually get hundreds of rows in one flat list. The grand total is rarely the question. You want the three charges from one vendor, the deposits over 5,000, or every line dated in March. A filter answers that in a couple of clicks and, unlike deleting rows, it is completely reversible: clear the filter and the full list is back. This guide covers the AutoFilter menu, filtering by several columns at once, the newer FILTER function, and the handful of reasons a filter stops behaving.
How do I filter data in Excel?
Click any cell inside your data, open the Data tab, and click Filter (the keyboard shortcut is Ctrl+Shift+L). Each header cell gets a drop-down arrow. Click the arrow on the column you want to narrow, and a list of every value in that column appears with check boxes. Uncheck Select All, tick only the values you want to see, and click OK. Excel hides the rows that do not match and shows the row numbers in blue to remind you a filter is on.
For a specific value in a long column, use the search box inside the drop-down instead of scrolling. Type part of the text, optionally with a wildcard such as an asterisk for any characters or a question mark for a single character, and press Enter to filter to the matches. To narrow further, open the drop-down on a second column and set a filter there too. Filters stack, so each one you add works on the rows the previous filters left visible.
How do I filter for multiple values in one column?
Open the column drop-down, leave Select All checked, and uncheck only the values you want to hide, or start from an empty list and tick the several values you want to keep. Every checked value stays visible, so you can show three vendors at once or four categories in a single filter. If you would rather describe the values than pick them, use Text Filters and the Contains option, or type a search term and use the checkbox that says Add current selection to filter to build the set up one search at a time.
For numbers, open Number Filters and choose a condition such as Greater Than, Between, or Top 10. This is the fast way to see, for example, every transaction over 1,000 or the ten largest amounts, which is exactly the kind of review you run on a freshly converted statement. Number Filters and value checkboxes work together, so you can pick two categories and then also require the amount to be above a figure.
How do I filter by more than one column?
Apply a filter to the first column, then open the drop-down on the next column and filter there as well. Because the second filter only sees the rows the first one left, the two conditions combine with AND logic: a row has to satisfy every active column filter to stay visible. Filtering the Category column to Fuel and then the Date column to March shows only the fuel charges in March.
Within a single column you can also combine two conditions. Open Number Filters or Text Filters, choose Custom Filter, and use the And or Or buttons to require both conditions or either one. And keeps a row only when both tests pass, so it narrows the list; Or keeps a row when either test passes, so it widens the list. That is the difference people trip on: And means fewer rows, Or means more.
| You want | Where to go | Result |
|---|---|---|
| A few named values | Column drop-down checkboxes | Only the ticked values show |
| Amounts over a number | Number Filters, Greater Than | Rows above the figure show |
| Text that contains a word | Text Filters, Contains | Rows with that word show |
| Two conditions in one column | Custom Filter, And or Or | Both, or either, must match |
| Two conditions across columns | Filter each column | All column filters must match |
What is the difference between AutoFilter and the FILTER function?
AutoFilter hides rows in place; the FILTER function copies the matching rows to a new location and leaves the original untouched. AutoFilter is the drop-down menu on your headers, and it is best for a quick, temporary look at your data. FILTER is a formula in Excel for Microsoft 365 and Excel 2021 that spills the matching rows into an empty area of the sheet, so you get a live, separate extract that updates when the source changes.
The syntax is =FILTER(array, include, [if_empty]). The array is the range you want back, include is a test that returns TRUE or FALSE for each row, and the optional third argument is what to show when nothing matches. For example =FILTER(A2:C500, B2:B500="Fuel", "None") returns every row where column B is Fuel and prints None when there are none. Use FILTER when you want a permanent, formula-driven extract, such as a summary tab that always shows the flagged transactions. Use AutoFilter when you just need to eyeball a subset and move on. If FILTER returns a #SPILL! error, the cells where the results need to land are not empty; clear them and the results appear.
Filtering is often the first move once a document is in a spreadsheet, right alongside deciding how to arrange the rows. Pairing a filter with a good sort of the same data is what turns a raw export into something you can actually review.
Why is my Excel filter not working?
The most common cause is a blank row or blank column inside your data. AutoFilter treats the first empty row or column it hits as the edge of your list, so anything past it is left out of the filter. Delete stray blank rows, or select the whole range yourself before turning the filter on, so Excel knows the true extent of the data. A converted PDF often carries in empty rows from page breaks, which is a frequent reason a filter seems to miss data.
Two more culprits show up on converted data. First, numbers stored as text do not respond to Number Filters, because Excel sees them as words, not values; if Greater Than returns nothing, your amounts are probably text and need converting to real numbers first. Second, extra spaces cause value checkboxes to split what looks like one entry into two, so "Fuel" and "Fuel " appear as separate items. Cleaning those up fixes both. If the Filter button itself is greyed out, the sheet is protected or you are inside an Excel Table that already has its own filter; unprotect the sheet or use the Table headers.
How do I clear or remove a filter?
To clear the filter on one column and show its hidden rows again, click that column's arrow and choose Clear Filter From. To drop every filter at once but keep the arrows in place, go to the Data tab and click Clear. To turn AutoFilter off entirely and remove the arrows, click Filter again on the Data tab or press Ctrl+Shift+L. None of these delete data; they only change what is visible.
One caution: if you copy a filtered list, Excel copies only the visible rows, which is usually what you want when you are exporting a subset. But if you delete visible rows while a filter is on, only the visible ones go, so clear the filter first if you meant to delete from the whole list. Once you have filtered down to the transactions you care about, the same clean sheet is what feeds the rest of your review, whether that is reconciling accounts or software that categorizes every expense for you.
Filter converted data with confidence
Filtering only helps if the underlying data is clean: real numbers, no stray blank rows, consistent labels. That starts with a good conversion. Turn your statement or report into a proper spreadsheet with the PDF to Excel converter or, for statements specifically, the bank statement converter, and your AutoFilter and FILTER results will match the source every time. From there, filtering to a vendor, a month, or every amount over a threshold takes seconds instead of a scroll through pages of PDF.