In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn column filters on or off. To search a column’s filter list, select a cell in that column, press Alt+Down Arrow to open its dropdown, enter a term in the Search box, select the matching values you want, and choose OK.
What the Excel filter shortcuts do
The shortcut people often mean by “filter search shortcut” is Ctrl+Shift+L. It adds filter arrows to the header row of a data range, or removes them if filters are already on. It does not, by itself, open a search field or search the whole worksheet. Searching happens inside the dropdown for a particular column.
For example, a sales list might have columns for Date, Region, Product, and Revenue. Turn on filtering, open the Product dropdown, and search for “mug.” Excel narrows the list of product values shown in that dropdown. Select the relevant value or values and click OK; Excel then hides rows that do not match the selections.
- Ctrl+Shift+L: turn AutoFilter arrows on or off.
- Alt+Down Arrow: open the filter dropdown for the active column when the selection is in a filtered range or table.
- Ctrl+F: open Find, which searches worksheet contents rather than narrowing a filter’s value checklist.
How to search a column’s filter list
These steps assume your data has one clear header row and no blank row separating the header from the records. Excel needs to identify the range that the filter applies to.
- Click a cell in the data. Press Ctrl+Shift+L. Filter arrows should appear beside the column headings. If they do not, check that the selection is within the data and that the worksheet is not protected.
- Click a cell in the column you want to search, or select that column’s header. Press Alt+Down Arrow to open its dropdown. You can also click the arrow in the header.
- Click the dropdown’s Search box and type a word, number, or part of a value. The checklist narrows to entries that match the search.
- Check the value or values to keep. Searching the checklist is not the same as applying the filter: the checkboxes determine which values remain included.
- Click OK. Excel hides rows whose entries in that column are not among the selected values.
Suppose the Product column contains “Travel Mug,” “Ceramic Mug,” “Notebook,” and “Desk Lamp.” Searching for “Mug” helps locate the two mug entries in the checklist. Select both if you want both types of mug in the results. If only “Travel Mug” is checked, the filter keeps that value alone. You can combine filters in more than one column—for example, Product contains the chosen mugs and Region is West—so the visible rows must satisfy both active column filters.
Turn filters on and off safely
Before applying filters, make sure the first row of the data has descriptive headings such as “Product” or “Region.” Avoid merged header cells and blank columns within the records. Excel uses the header row to label each dropdown; unclear or missing headings make it harder to pick the right field.
When you use Ctrl+Shift+L with a cell in a contiguous data range selected, Excel normally detects the range and puts filter arrows on its headings. If the data is an Excel table, its headers already have filter dropdowns, so you can search a column without first toggling AutoFilter on. A table is also useful when records are added over time because the table can expand to include new rows.
Turning the arrows off removes the AutoFilter interface; it is not the same action as clearing the current criteria. To show all rows while keeping the arrows available, open the relevant dropdown and choose Clear Filter From that column, or use the clear-filter command on the Data tab. To clear filters across a range, use Data > Sort & Filter > Clear. The exact ribbon layout can vary slightly with window size, but the command is on the Data tab.
What the Search box searches—and what it does not
The Search box in a filter dropdown helps you find entries in that column’s list of values. It is especially useful when the checklist is long. It does not search every cell in the workbook, and it does not automatically select every matching value as a final filter. Review the narrowed checklist, choose the entries to include, and apply the dropdown.
AutoFilter works with the values in the cells, not with how a value happens to look after formatting. A date might display as “Nov 3” while its underlying value includes a year and time. A number might display with a currency symbol or rounded decimals. If searching the displayed text does not find what you expect, check the underlying data type and the value shown in the cell. Dates and numbers can also be filtered using their date or number criteria rather than treating them as ordinary text.
Search behavior is not the same as a sophisticated text query. If you need a condition such as “begins with,” “ends with,” “contains,” or a numeric range, use the filter’s text, number, or date filter options where available. Those choices let you set a condition directly instead of relying on the checklist search to locate individual entries.
Filter search compared with Find
Use the filter dropdown when your goal is to display a subset of records while keeping each record’s other columns together. For instance, filtering a customer table to show the rows for one city leaves each customer’s name, email, and order information on the same row. The other records are hidden, not deleted.
Use Ctrl+F when you want to locate a matching cell, move between occurrences, or search beyond one filtered column. Find is a lookup tool, not a row-filtering tool. It can locate a cell containing a phrase without creating a persistent visible subset of the dataset. If you use Find while a filter is active, remember that hidden rows may affect what you can see; clear the filter if you need to inspect the entire range.
A third option is Data > Advanced for more involved criteria, or a worksheet formula when you need a separate, dynamically returned result. Those approaches can be helpful for repeatable reports, but they are usually unnecessary for a quick search in a column’s dropdown.
Common problems and practical fixes
- No filter arrows appear: Click inside the data before using the shortcut. Check that the range has a header row, is not interrupted by blank rows or columns, and is not protected in a way that prevents filtering. You can also select the data and choose Data > Filter.
- The dropdown opens for the wrong column: Close it, select a cell under the intended heading, then use Alt+Down Arrow again. Clicking the arrow directly avoids ambiguity.
- A value seems to be missing: Clear any existing filter that could hide relevant rows, then reopen the dropdown. Also check for extra spaces, inconsistent spelling, or entries stored as different data types. “North” and “North ” can look alike but are not identical values.
- Typing does not go into Search: The dropdown may not have focus in its Search box. Click the box directly before typing. If keyboard navigation is important, use Tab to move through the menu and watch for the focus indicator; the number of presses can depend on the dropdown state.
- Some rows are unexpectedly outside the filter: Look for blank rows or columns that split the list, or for a second header row that Excel interpreted as data. Convert a clean, rectangular range to a table with Insert > Table if that suits the dataset.
- Rows appear to have disappeared: A filter hides nonmatching rows rather than deleting them. Clear the filter to reveal the full list before editing or copying records.
Windows, Mac, and Excel for the web
The keyboard instructions above are for Excel for Microsoft 365 on Windows. On a Mac, Control+Shift+L may apply or remove filters depending on the Excel version and keyboard setup; if it does not work, use Data > Filter. To open a dropdown, Option+Down Arrow is the corresponding Mac-style key combination in many Excel configurations, while clicking the header arrow is the dependable alternative.
Excel for the web has a browser-based interface, and keyboard shortcuts can be affected by the browser or operating system. You can use the filter arrows and the Search box directly, or look up the shortcut shown in Excel’s current menus or keyboard-shortcut help. If a shortcut is intercepted by the browser, use the ribbon or dropdown rather than assuming the filter is broken.
Frequently Asked Questions
What is the shortcut to search a filter in Excel? Use Ctrl+Shift+L to turn filter arrows on, then open the target column’s dropdown with Alt+Down Arrow and use its Search box. The first shortcut enables filters; it does not itself perform the search.
Can I search a filter without using the mouse? You can use the keyboard to open the dropdown and navigate its controls, but focus behavior can vary. Press Alt+Down Arrow, use Tab to move focus until the Search box is selected, type the term, then navigate the checklist and confirm the choices. Clicking Search is often faster and more predictable.
Does Excel’s filter Search box find partial words? It can help narrow the value checklist using a portion of a value, such as “Mug” among product names. If your goal is to set a particular text condition rather than select listed values, open the text-filter options and choose the appropriate condition.
How do I remove a filter but keep the dropdown arrows? Open the filtered column’s dropdown and choose Clear Filter From that column. To clear all active filter criteria at once, choose Data > Sort & Filter > Clear. The arrows remain available for another search.
Does filtering delete the rows that do not match? No. A filter temporarily hides rows that do not meet the selected criteria. Clear the filter to show them again; do not treat a filtered view as a deleted or permanently reduced dataset.
Related
- Excel Text Box Wrap Text: How to Enable It
- Excel Template for a Social Media Calendar
- Excel Job List Template: Track Applications and Follow-Ups
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- XLOOKUP Excel Column Match: Find a Column by HeaderTo match a value in an Excel column and return a value from another column, use XLOOKUP with…
- Excel MID Function: Extract Text From a CellIf the text you want to extract is in A2, use =MID(A2,5,5) to return five characters starting at…
- Excel Formula for Percentage of Total: Clear ExamplesTo calculate a percentage of a total in Excel, divide the part by the total: if the value…
- Excel IF Formula Examples: Tests, Logic, and ErrorsExcel’s IF formula checks whether a condition is true or false and returns one result for each outcome.…
- Excel IFS in Conditional Formatting: How to Use ItYes. In Excel for Microsoft 365 on Windows, you can use the IFS function in a conditional-formatting formula,…
- Excel Format A to Z: How to Sort Rows and Lists SafelyTo sort data from A to Z in Excel for Microsoft 365 on Windows, click a cell in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.