To filter an Excel table by keyword, open the filter arrow in the column you want to search, type a word or phrase in the menu’s Search box, and select the matching results. For a contains-style filter, choose Text Filters > Contains, enter the keyword, and select OK; Excel hides rows that do not match without deleting them.
How Excel’s keyword filters work
Excel’s built-in filters act on a column’s values. A keyword search in a column such as Description looks for matching text in that column, then shows the entire rows containing those values. This is useful for narrowing a list of orders, support tickets, inventory items, or survey comments without changing the underlying data.
Excel text filtering is generally not case-sensitive: searching for “urgent” can find “Urgent” as well as “URGENT.” A contains search can match text anywhere in a cell, not just at the beginning. For example, a search for “pump” can match “Pump replacement,” “inspect pump,” and “replacement pump seal.” It does not normally match a different word simply because that word has similar letters.
A filter changes which rows are displayed, not the stored values. Hidden rows remain part of the table and can be shown again by clearing the filter. This is different from deleting rows or removing text, so filtering is a reversible way to inspect a subset of a list.
Filter a table by keyword: step by step
- Click a cell inside the Excel table. If your data is not already a table, select the data, choose Insert > Table, confirm that the range is correct, and make sure My table has headers is selected if the first row contains headings.
- Find the arrow beside the heading of the column you want to search, such as Description or Product. If filter arrows are not visible, choose Data > Filter while a cell in the range is selected.
- Open that column’s arrow menu. Type the keyword into the Search box. Excel narrows the displayed list of distinct values as you type.
- Select the matching value or values in the list, then select OK. Excel displays the rows whose cells contain the selected values.
The menu’s Search box is handy when you know a value and want to find it quickly in the checkbox list. For a substring search that can match part of a longer cell entry, use Text Filters > Contains instead. Enter the word or phrase in the dialog and confirm. The menu wording can vary slightly by Excel build, but the Text Filters option is available from a text column’s filter menu.
For example, if a Product column has “Blue desk lamp,” “Desk organizer,” and “Blue notebook,” searching the filter list for “Blue” helps select the two values that contain that word. Choosing Text Filters > Contains and entering “desk” instead matches both desk-related entries, even though the phrase occurs in different positions.
Search one column or combine several filters
Each table column has its own filter. A keyword search on Description does not search every other column automatically. To find a phrase anywhere in a record, choose a column likely to hold it, or apply filters to more than one relevant text column and inspect the results.
Filters applied to separate columns work together: Excel shows rows that meet the selected condition in each filtered column. For example, filtering Status to “Open” and Description to contain “delivery” shows open rows whose descriptions also contain that keyword. In other words, the conditions across columns are combined as an AND, not an either-or search.
Within a column, you can select more than one listed value using the checkboxes. If you need more specific conditions on that same column, use Text Filters. The Custom AutoFilter dialog lets you define two text conditions and choose whether they are joined by And or Or. For instance, use Or to show descriptions containing “repair” or “replacement.” This is different from filtering two separate columns, where both column conditions must be met.
Contains, begins with, and exact matches
Excel provides several text-filter choices because “find this keyword” can mean different things. The most useful options are:
- Contains: matches the search text anywhere in a cell. Use it for a word or phrase embedded in a longer description.
- Does Not Contain: excludes cells that include the specified text.
- Begins With: matches text at the start of the cell, useful for codes that share a prefix.
- Ends With: matches text at the end, which can help with suffixes or consistent endings.
- Equals: looks for a whole cell value, such as a specific category or a complete product name.
These options help avoid a common mismatch: a reader may expect a search for “cat” to find only the standalone word, while Contains can also match “catalog.” If word boundaries matter, a basic text filter may not be precise enough. You can use a carefully designed helper column or a formula-based approach, depending on how the source text is structured.
Excel’s custom text-filter criteria can also use wildcard characters: an asterisk (*) represents any number of characters, and a question mark (?) represents one character. A tilde (~) can be used to treat a wildcard character literally. Wildcards are useful for patterns, but they can make a filter broader than intended; review the displayed results before relying on them.
Use a formula when you need a live results list
A normal table filter hides nonmatching rows in place. If you instead want a separate results area that updates when the source data changes, Excel for Microsoft 365 can use the FILTER function. This is useful for a report or dashboard that should show matching records while leaving the source table visible.
Assume a table named Table1 has columns ID, Description, and Owner, and its Description column contains “Urgent: replace pump,” “Routine inspection,” “Customer says urgent delivery,” and “Closed – awaiting parts.” Enter this formula in an empty cell outside the table:
=FILTER(Table1,ISNUMBER(SEARCH("urgent",Table1[Description])),"No matches")
The formula returns the two rows whose Description contains “urgent”: “Urgent: replace pump” and “Customer says urgent delivery.” SEARCH finds the text without regard to letter case, and ISNUMBER turns a successful match into TRUE for FILTER. If there are no matching rows, the formula displays “No matches.” Keep the spill area clear so Excel can display all returned rows. FILTER is available in Microsoft 365 and Excel 2021 or later; it is not available in older perpetual versions such as Excel 2019.
For a case-sensitive search, FIND can be used in place of SEARCH in a similar formula. Formula results are separate from the original table and do not replace its built-in filters. If you only need to temporarily inspect matching rows, the column dropdown is usually simpler.
Common problems and how to fix them
- The keyword does not find a row: Check the column you searched, spelling, punctuation, and whether the text is actually in that cell. A phrase with a different spacing or a nonbreaking space may not match the visible text as expected.
- Only some rows appear: Look for filters already active on other columns. Since separate column filters combine, an existing Status or Date filter may exclude otherwise matching records. Use the column menus to clear conditions you no longer need.
- The filter arrow is missing: Click inside the table and confirm that its header row is present. If you are working with a plain range, select a cell in the range and choose Data > Filter, or convert the range to a table with Insert > Table.
- New rows are not included: If the data is a proper Excel table, typing directly below it generally expands the table. If it is an ordinary filtered range, newly added rows may fall outside the range; adjust the range or convert it to a table.
- The keyword matches too much: Use Equals instead of Contains for a complete value, or narrow the condition with another filter. Remember that Contains can match text embedded inside a longer word.
- The visible data looks incomplete: Filtering hides rows, and rows may also be hidden manually. Clear the filters and check whether the full list returns before assuming records have been deleted.
One practical precaution is to check the filter indicators in the column headings when results seem unexpectedly limited. Clear an individual column’s filter from its menu, or use Data > Clear to clear filters on the current range or table. Clearing a filter restores rows; it does not remove the table or its contents.
Choosing between the dropdown and a formula
Use the built-in dropdown filter for quick exploration, one-off searches, or work where the filtered rows should remain in the same table. It is easy to combine with category, date, and number filters, and it does not require a formula or a separate output area.
Use FILTER when you need a second, automatically updating list of matching rows. It is especially convenient when a report needs to show a subset while preserving the full source table on the worksheet. The trade-off is compatibility: people opening the workbook in older Excel versions may not be able to calculate the formula, and the results need enough empty cells to spill into.
For a one-time handoff, you can also apply the built-in filter and copy the visible rows to another location. Be clear that the copied selection is a snapshot; unlike a FILTER formula, it will not automatically update as the original data changes. Choose based on whether you need a temporary view, a live output, or a fixed extract.
Frequently Asked Questions
Can Excel filter a table by part of a word?
Yes. Open the relevant column’s filter arrow, choose Text Filters > Contains, and enter the character sequence. A contains filter can match it in the middle of a cell’s text as well as at the beginning.
Can I search for a keyword in multiple columns at once?
The standard column filter searches the column whose menu you opened, not every column in the table. You can filter multiple relevant columns, use a helper column that combines or checks text, or use a formula designed to search across the fields you need.
Does filtering delete rows that do not match?
No. Excel temporarily hides rows that fail the filter. Clear the filter to display them again. Deleting rows is a separate action and should not be necessary just to narrow a table.
How do I remove a keyword filter?
Open the filtered column’s dropdown and choose Clear Filter From [column name], or use Data > Clear to clear filters from the current range or table. The exact menu wording may include the column’s heading.
Can I make an Excel filter search case-sensitive?
The built-in text filter is not case-sensitive. For a case-sensitive live results list, use a formula based on FIND rather than SEARCH, and ensure the workbook is opened in a version that supports the formula you choose.
Make keyword filtering reliable
For most everyday searches, the quickest path is the column dropdown followed by Text Filters > Contains. Use the checkbox search when you are selecting known values, and use separate column filters when the results must satisfy multiple conditions. If you need a live list in a different part of the sheet, FILTER offers a formula-based alternative in current Excel versions. In all cases, verify the visible matches and check for other active filters before treating the result as a complete list.
Related
- Excel Data Validation List: Remove Duplicates
- Excel Data Validation List Search: Setup and Fixes Guide
- Excel Data Validation List: Can You Pick Multiple?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Budget Spreadsheet Examples: Templates and FormulasBudget spreadsheet examples range from a simple monthly income-and-expense list to zero-based, annual, and small-business budgets. For a…
- Excel Concatenate String Examples: Formulas That WorkTo concatenate strings in Excel, join cell references and text with the ampersand operator (&), or use CONCAT…
- Days Between Dates in Excel: TODAY Formula and ExamplesTo calculate the number of days from a date in Excel to today, subtract the date cell from…
- Excel LEFT: How to Return Text Before a Specific WordTo return everything before a particular word in an Excel cell, use =TEXTBEFORE(A2,B2) in Microsoft 365, where A2…
- Excel Absolute Reference: How to Lock a Cell in a FormulaTo make a cell reference absolute in Excel, put a dollar sign before both its column letter and…
- Excel Sum a Range of Cells: Formulas, Tips, and FixesTo add a range of cells in Excel, use the SUM function: if the numbers are in A1…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.