Excel Text Filter Shortcuts: Search and Filter Faster

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off, then press Alt+Down Arrow in a column header to open its filter menu. To filter text, choose Text Filters and select a condition such as Contains, or use the menu’s search box to find listed values.

Shortcuts for the Most Common Filter Tasks

The main shortcut sets up the filter controls; other keyboard actions help you work inside them. These are the useful starting points on Windows:

  • Ctrl+Shift+L: Turn AutoFilter on or off for the current data range or table.
  • Alt+Down Arrow: Open the filter drop-down for the selected column header.
  • Arrow keys: Move through the filter menu and its choices. Press Enter to activate a highlighted item; use the right arrow to open a submenu where appropriate.
  • Esc: Close an open menu without choosing a filter.

On Excel for Mac, the AutoFilter toggle is generally Command+Shift+F; Option+Down Arrow opens a selected column’s filter menu. Mac keyboard layouts and app versions can affect how a key combination is entered. The Windows shortcut Ctrl+Shift+L is not the Mac equivalent. If a shortcut is intercepted by macOS or does not work in your build, use the ribbon’s Data > Filter command. Ribbon labels may vary slightly by platform.

Turn on AutoFilter and Open a Column Menu

AutoFilter adds a drop-down control to each header in a selected data range. Click a cell in the data, then press Ctrl+Shift+L. Excel usually identifies the contiguous range around that cell and places filter arrows in its header row. If Excel selects the wrong range, select the full range—including its headers—before using the shortcut.

Click a header’s drop-down arrow, or select that header cell and press Alt+Down Arrow. The menu contains sorting commands, a list of values, and filtering options. A small funnel on a header indicates that the column has an active filter; a plain arrow means a filter control is available but does not, by itself, show that values are being excluded.

For a new worksheet range, use one header row with a distinct label for every column. Avoid blank header cells and completely blank rows or columns inside the data: they can make Excel detect only part of the range. Formatting the data as a table with Insert > Table is another reliable option. A table includes filter arrows automatically, so you generally do not need to toggle AutoFilter on separately.

Search the Value List Versus Apply a Text Condition

The search box in a filter menu and the Text Filters commands can look similar, but they answer different needs. Use the search box when you want to locate one or more distinct values already present in the column. For example, searching for “North” in a Region column can help you find and check the North value in the list. The resulting filter displays the selected values.

Use a text condition when the rule itself matters, particularly if there are many different entries. For instance, Text Filters > Contains can show all cells that contain “north,” including entries such as “Northwest” and “North Region.” The condition is more useful than manually checking each matching distinct value when new or numerous labels are involved.

To search the value list, open the header menu, click or navigate to its search field, type a term, and select the values you want included. Check the displayed boxes carefully: filtering by a chosen value list keeps those checked entries and hides unchecked entries. Clear the search text when you need to see the full list again. Searching the list does not create a permanent text rule; it narrows the visible choices in that menu.

Use Text Filters for Contains, Begins With, and More

To create a condition, open the relevant column menu and choose Text Filters. Select a condition such as Equals, Does Not Equal, Begins With, Ends With, Contains, or Does Not Contain. Enter the comparison text in the dialog and confirm. Excel then hides rows that do not meet the condition.

For example, suppose a Comments column contains “Awaiting supplier reply,” “Supplier confirmed,” and “Customer called.” A Contains condition for “supplier” keeps the first two rows and hides the third. Text filters are generally not case-sensitive, so “supplier” matches “Supplier.” If you need a case-sensitive test or a more specialized rule, a formula-based helper column may be more suitable than AutoFilter.

The custom text-filter dialog can combine two conditions. Choose And when both conditions must be true, such as text that begins with “INV-” and contains “2026.” Choose Or when either condition can be true, such as text that contains “urgent” or “priority.” Keep in mind that each condition operates on the text in that column; filtering another column adds another restriction to the displayed rows.

Use Wildcards for Flexible Text Matching

In applicable Excel filter criteria, wildcard characters can match variable text. An asterisk (*) represents any number of characters, including none; a question mark (?) represents one character. A tilde (~) escapes a wildcard when you want to search for the literal character rather than use it as a pattern.

  • AB* can match text beginning with AB, such as “AB12” or “AB order.”
  • *east can match text ending in “east,” such as “Northeast.”
  • J?n can match three-character text such as “Jan” or “Jun.”
  • ~* is used to match a literal asterisk in text rather than treating it as a wildcard.

For straightforward rules, the named Text Filters options are easier to understand and less error-prone than typing wildcard patterns. Wildcards are helpful when a text pattern has a variable part, but test the result against a few known rows—especially if the data contains punctuation, spaces, or inconsistent naming.

Combine Filters and Keep the Data in Context

Filters on separate columns work together: Excel displays rows that satisfy the active filter in every filtered column. For example, filtering Region to “West” and Status to “Open” shows open records in the West. This is an AND relationship between columns. Within one column, the custom filter dialog lets you choose whether its two text conditions use AND or OR.

Filtering hides rows temporarily; it does not delete the underlying records or change their cell values. The remaining rows may not be consecutive, and row numbers can skip because some rows are hidden. Copying only visible results can be useful for a report, but check the selection before copying so you do not mistake a filtered view for the complete dataset.

When several filters are active, clear only the one you intend to change. Open that column’s menu and choose Clear Filter From followed by the column name. To clear filtering across the range, use Data > Sort & Filter > Clear. The exact group placement can differ with ribbon layout, but Clear removes the applied filter criteria while leaving the filter controls available.

Common Problems and Practical Fixes

  • The shortcut does nothing: Click inside the data first, confirm that the worksheet is active, and try Ctrl+Shift+L again. On Mac use Command+Shift+F. If another application or system setting captures the keys, use Data > Filter.
  • The filter arrow is missing: AutoFilter may be off, the selected range may not include the intended header, or Excel may have detected only part of the data. Select the complete range and toggle the filter again.
  • A matching-looking row is missing: Check for leading or trailing spaces, alternate spellings, and other active filters. The filter criteria may be correct while another column’s filter excludes that row.
  • Text Filters is unavailable or behaves unexpectedly: Confirm that the column contains text values and that you opened the menu for the intended field. A column containing mixed numbers, dates, and text can be harder to interpret; inspect the cell contents and use the appropriate filter category.
  • New records are not included: If you used a plain range, new rows added outside its detected boundaries may not inherit the filter. Convert a well-structured range to a table or reselect the expanded range and apply AutoFilter.

A useful habit is to clear old criteria before starting a new analysis, then apply filters one column at a time. This makes it easier to identify which condition removed a row. If results still seem wrong, temporarily clear all filters and confirm the exact spelling and contents of the source cells.

Frequently Asked Questions

What is the shortcut to add filter arrows in Excel?
On Windows, select a cell in the data and press Ctrl+Shift+L. On Mac, use Command+Shift+F. The shortcut toggles AutoFilter; it does not itself choose a text condition.

How do I open an Excel filter with the keyboard?
Select a cell in the column header and press Alt+Down Arrow on Windows. On Mac, Option+Down Arrow generally opens the selected filter menu. Use the arrow keys and Enter to move through available choices.

How do I filter cells that contain a word?
Open the column’s filter menu, choose Text Filters > Contains, enter the word, and confirm. To find listed values containing a term instead, use the menu search box and select the matching values.

Can I filter for two words at once?
Yes. In the custom text-filter dialog, enter two conditions and choose And if both must match, or Or if either one can match. You can also filter another column to add a separate restriction.

Does filtering delete rows from my spreadsheet?
No. AutoFilter hides rows that fail the criteria; it does not delete them. Clear the filter to show the rows again. Avoid deleting visible rows unless you intentionally want to remove data.

Choosing the Fastest Method

Use Ctrl+Shift+L when you need filter arrows quickly, the drop-down search box when you want to select known values, and Text Filters when you need a reusable-looking rule such as “contains this phrase” or “begins with this code.” For larger datasets, a formatted table keeps the filtered range easier to manage as records are added. Whichever method you choose, verify the active funnel icons and clear old criteria before drawing conclusions from a filtered view.

Related

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.