How to Filter in Excel and Find the Exact Rows You Need

To filter a list in Excel, select a cell in your data, choose Data > Filter, then open a column’s drop-down arrow and select the values or conditions to show. Filtering hides rows that do not match; it does not delete them, so you can focus on a smaller part of your worksheet and restore the full list later.

The instructions below are for Microsoft Excel for Microsoft 365 on Windows. Before filtering, make sure your list has a header row and that each column contains one kind of information, such as dates, names, or sales amounts. A clean, continuous table is easier to filter accurately.

What You’ll Need

An Excel workbook containing a list or table of data.
A header at the top of each column, such as Date, Region, or Status.
Permission to edit the workbook if it is protected or shared with editing restrictions.

Step-by-Step

Check the layout of your data. Put one set of column headings in a single top row, with one record per row below. For example, an order list might have Order Date, Customer, Region, and Amount as headings. Avoid merged cells in the data area, blank rows or columns splitting the list, and completely empty header cells. These can make Excel detect only part of your information or apply confusing filter labels. If the data is already an Excel table, use its existing header arrows; you do not need to add a second filter.
Select a cell inside the list. Click any populated cell in the range you want to filter. You usually do not need to drag over every row and column: Excel can detect the surrounding continuous data. If nearby content should not be included, select the exact range first, including its header row. Check the selection carefully if the worksheet has another data block directly beside or below it.
Turn on the filter controls. On the Windows ribbon, choose Data > Filter. Small drop-down arrows should appear beside the headings in the detected range. You can also toggle the filter on or off with Ctrl+Shift+L. If the arrows do not appear, confirm that the active cell is in the list and that the worksheet is not protected against filtering.
Open the arrow for the column you want to filter. For example, open the Region arrow to show selected regions, or the Amount arrow to set a numeric condition. The menu may include a search box, a checklist of distinct values, sort commands, and options such as Text Filters, Number Filters, or Date Filters. The available options depend on what Excel recognizes in that column.
Choose values or a condition. To show particular categories, clear Select All, check the values you want to keep, and select OK. Use the search box to find an item in a long checklist, then check the matching value. To filter by a rule instead, open the relevant filter option. For example, choose Number Filters > Greater Than, enter a limit, and confirm. For dates, you can select listed dates or use date conditions such as a range, depending on the menu and your data.
Add a filter on another column if needed. Open a second heading’s arrow and select another set of values or condition. Excel keeps rows that meet the filters across the different columns at the same time. For example, filtering Region to West and Status to Open shows only rows that are both in the West and open. Within one column, selecting several checklist values generally shows rows matching any of those selected values.
Review the filtered results. Look at the visible rows and the filter icons in the headings. A funnel icon indicates that a column has a filter applied; a regular arrow may indicate no active filter there. Confirm that the headings and displayed records match what you meant to find. If the result seems incomplete, check whether your criteria exclude records with spaces, misspellings, blanks, or unexpected date or number formats.
Clear one filter or restore all rows. To remove a condition from one column, open that column’s arrow and choose Clear Filter From followed by the column name. To remove all active filters while keeping the arrows, choose Data > Clear. To turn the filter controls off, choose Data > Filter again. Clearing filters shows hidden records again; it does not undo edits or remove rows.

In Excel for Mac, the ribbon also has a Filter command on the Data tab; select a cell in the list and use that command, then work with the heading arrows in the same way. Excel for the web has a Data tab and filter controls too, though the ribbon layout and some menu options can differ. If you are working in a shared workbook, other people may also see changes to the displayed filter results, depending on the workbook and view.

Common Mistakes

Leaving the header row out. If you select only the data rows, Excel may treat the first record as a heading or show unhelpful filter labels. Include the actual headings when selecting the range.
Expecting filters to delete unwanted records. A filter only hides rows temporarily. Copying visible results, deleting rows, or editing cells is a separate action, so check what is selected before making changes.
Using inconsistent data in one column. A column with dates stored both as real dates and as text may offer confusing choices or sort in an unexpected order. Likewise, values such as 100 and $100 may not be treated consistently if some are text. Keep each column’s entries in a consistent format.
Forgetting a filter is active. A filtered list can look like it is missing records. Check for funnel icons and clear the filters before assuming rows have disappeared or before sharing the workbook as a complete list.
Filtering a partial range by accident. A blank row or column can interrupt Excel’s automatic range detection. If some headings have arrows and others do not, or some records remain unaffected, inspect the range and remove unintended gaps where appropriate.

Tips

Convert a changing list to a table. Select a cell in the data and choose Insert > Table, making sure My table has headers is selected if your first row contains headings. Tables provide filter arrows automatically and generally expand when you add records directly below them. This is useful for lists that grow over time.
Use the search box for long lists. In a heading’s filter menu, type part of a value to narrow the checklist. Select the intended result and confirm the filter. Clear the search text or reopen the menu if you need to choose additional values.
Combine filters to narrow a result. Apply a category filter first, then a date or number filter. This can be easier to check than selecting many conditions in one menu. Remember that filters on different columns work together, so each additional condition can reduce the visible rows.
Sort and filter are different actions. Sorting changes the order of records; filtering hides records that do not meet criteria. Both commands are available from the heading menus, so read the menu choice before clicking if you need to preserve the current order.
Make the full list easy to restore. If you are handing the workbook to someone else, clear filters or clearly indicate which filters are active. This helps prevent a reader from mistaking a partial display for the entire dataset.
Use an explicit range when neighboring data could be included. If two lists touch, select the intended list including its headings before choosing Data > Filter. This prevents Excel from applying arrows to an unintended block.

Troubleshooting

No filter arrows appear: Click a cell inside the list and choose Data > Filter again. Check that the worksheet is not protected, and look for merged headings or a blank row separating the active cell from the rest of the list. If needed, select the full range, including the header row, before turning on Filter.

Some rows or columns are not included: Excel may have detected a smaller block because of an empty row or column. Turn off the filter, select the complete intended range, and turn it back on. For a regularly updated list, consider converting the range to a table.

A value you expect is missing from the checklist: Clear any search text in the filter menu and check whether another column is also filtered. Look for leading or trailing spaces, spelling variations, and values stored in inconsistent formats. Clearing all filters with Data > Clear can help you confirm whether the record is present.

A date or number filter behaves unexpectedly: Check whether the entries are genuine dates or numbers rather than text. Mixed formats can cause Excel to offer different menu choices or compare values differently than expected. Correct the source values consistently, then reopen the filter menu and apply the condition again.

The rows seem to have vanished: Open the column menus and look for active criteria, or choose Data > Clear to remove all filters. Filtering hides nonmatching rows, so they should reappear when the filters are cleared. If they do not, check for manually hidden rows or whether the records are outside the filtered range.

Frequently Asked Questions

Can I filter more than one column at once?
Yes. Apply a condition in one heading’s menu, then apply another in a different heading. Excel shows rows that satisfy the conditions across the columns, so the result becomes more specific.

Does filtering change or delete my data?
No. It hides rows that do not match the selected criteria. Clear the filter to display them again. Editing or deleting the visible records is a separate action.

How do I filter for blank cells?
Open the relevant column’s arrow and look for (Blanks) in the checklist. Select it to show empty cells, or clear it to exclude them. If blank-looking cells do not appear there, they may contain spaces or formulas that return an empty string rather than being truly empty.

Can I filter by part of a word?
Yes. Open the text column’s arrow and use Text Filters, such as Contains, then enter the text to match. You can also use the menu’s search box to locate checklist values, but a text condition is more useful when you want to match a phrase within different entries.

How do I remove every filter but keep the arrows?
Choose Data > Clear to clear the applied criteria while leaving the filter controls available. Choose Data > Filter to turn the controls off as well.

Can I filter a list that has no headings?
It is better to add a clear heading to every column first. Excel uses the top row to label the filter menus, and meaningful headings make it easier to apply the right condition and understand the results.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.