Excel Table Filter by Cell Value: Steps, Tips, and Fixes

Formulas & functions · Updated November 19, 2026

To filter an Excel table by the value in a cell, right-click that cell and choose Filter > Filter by Selected Cell’s Value. Excel hides rows that do not match; it does not delete them. You can also use the column’s filter arrow to search for a value or set a more specific condition.

Use the selected cell’s value as a filter

This is the quickest method when the cell already contains the value you want to keep. It works when filtering is available for the list or table, such as when the data is formatted as an Excel table or has AutoFilter turned on. In Excel for Microsoft 365 on Windows:

  1. Click a cell in the table’s data area, not its header row. For example, click a cell containing West in the Region column.
  2. Right-click the cell, point to Filter, and select Filter by Selected Cell’s Value.
  3. Excel filters that column to show matching values. A filter icon on the column’s dropdown indicates that a filter is active.

The selected cell does not need to be the first row or the only occurrence. If the value appears in several rows, Excel displays all matching rows. If it appears only once, only that matching row remains visible. For a text value such as West, the command filters for that value rather than for every value that merely contains the same letters.

On a Mac or in Excel for the web, the context-menu wording or availability can differ. The reliable alternative is to open the column’s filter dropdown and select the value there. The dropdown approach also gives you more control over conditions such as contains, begins with, or is greater than.

Filter with a table column dropdown

Excel tables normally show a dropdown arrow in each header cell. If you do not see one, click inside the table and look at the header row. You can also use Data > Filter to turn filtering on for a selected data range. If the data is not yet a table, create one with Insert > Table, then confirm whether the range has headers.

Open the arrow for the column you want to filter. The menu usually includes a search box, a checklist of values, and options for filtering by the type of data in that column. To show one value, clear (Select All), select the desired value, and click OK. To show several values, select each one you want included before confirming. The checklist represents distinct values in the column, not individual rows.

The search box helps when a column contains many distinct entries. Search for a name such as Northwind, select the matching item in the results, and apply the filter. Searching narrows the checklist; it does not necessarily apply a filter until you confirm the selection. To return to all values for that column, open its dropdown and choose Clear Filter From followed by the column name, or select all values again.

What filtering does to table data

A filter changes which rows are displayed, not the underlying contents of the table. Rows that fail the condition are hidden temporarily. Clearing the filter makes them visible again, so filtering is different from deleting rows, removing duplicates, or copying only the visible records into a new list.

This distinction matters when you work with totals or copy data. Functions such as SUBTOTAL can calculate over visible records in ways suited to filtered lists, while a normal SUM may include values in rows that are currently hidden by a filter. Also, selecting and copying a filtered range requires care: Excel commonly copies visible cells, but check the selected range and the pasted result before relying on it for a report or data transfer.

Filtering also does not rearrange records. Use the sort commands separately if you want values alphabetized or ordered by date or number. A filtered table can be sorted at the same time, but clearing a filter and undoing a sort are separate actions.

Choose an exact value or a condition

Filtering by the selected cell’s value is best for a simple exact match. Use the dropdown’s filter options when the goal is broader or more precise than keeping one listed value. Available options depend on the data type Excel recognizes in the column:

  • Text columns: use choices such as Text Filters > Contains, Begins With, or Equals. For example, Contains can show product descriptions that include the word cable, even if the descriptions are not identical.
  • Number columns: use Number Filters to set conditions such as greater than, less than, or between two values. This is useful for a quantity threshold rather than a single quantity.
  • Date columns: use date-filter options to select a date, a range, or a period such as a month or year. Excel may group dates in the menu when it recognizes them as dates.
  • Blank entries: use the blank or nonblank choices in the checklist when you need to find missing values. A cell containing a formula that returns an empty string is not always treated the same way as a truly empty cell.

Excel interprets a column according to its contents and formatting, so mixed data can make the menu less predictable. For instance, numbers stored as text may not behave like numeric values in a number filter. If a date appears as text, date-grouping options may not appear. Standardizing the column’s data is often a better fix than trying increasingly complex filter criteria.

Combine filters across columns

You can filter more than one table column at a time. For example, first filter Region to show West, then filter Status to show Open. Excel displays rows that meet both active column filters: in this example, the record must be in West and have an Open status. This is an AND relationship between the separate column filters.

Within a column, selecting multiple checklist values usually means show rows matching any selected value. Selecting West and East in Region therefore includes rows for either region, while an additional Status filter further narrows those results. This is useful for everyday questions such as finding open orders in two regions without changing the source data.

Applying a new filter in a column changes that column’s current filter. It does not usually clear filters in other columns. To understand why rows are missing, inspect each header for a filter indicator and clear filters one at a time. The table’s visible results are the combined outcome of all active filters.

Common problems and how to fix them

  • The filter command is missing: confirm that filtering is enabled. Click inside the table and check for header dropdowns; if needed, choose Data > Filter. A protected worksheet or a selection outside the filtered range can also limit what you can do.
  • Some expected rows do not appear: another column may still have an active filter. Clear that filter or use Data > Sort & Filter > Clear to clear active filters across the range, then apply the intended conditions again.
  • Values that look identical behave differently: check for leading or trailing spaces, different spellings, hidden characters, or numbers stored as text. The checklist may treat entries that look alike on screen as distinct underlying values.
  • New rows are not included: if the data is an Excel table, enter the new records directly below it or expand the table so the rows belong to it. For a filtered ordinary range, check that the filter range includes the added rows.
  • The filter arrow is not visible: check that the header row is included and that filtering has not been turned off. On a table, the header controls may also be hidden by a setting or window layout.

When troubleshooting, clear filters before deciding that data is missing. A filtered table can make it appear that records have disappeared even though they are only hidden. If other people use the workbook, consider leaving a visible indication that filters are active or documenting the intended view.

Tables, ordinary ranges, and other options

An Excel table is often the easiest format for ongoing records because its header controls are built in and the table can expand as data is added. Tables also support structured references and table styles, but those are separate from filtering itself. A regular range can be filtered too: select the data, including headers, and choose Data > Filter. In either case, avoid blank rows or unrelated data inside the range, because they can interfere with how Excel identifies the list.

If you need to produce a separate extract rather than temporarily hide rows, copy the filtered results to another worksheet and verify what was copied. Another option in Microsoft 365 is the FILTER worksheet function, which returns matching rows into a separate area; it is a formula-based result, not the same as applying a table dropdown filter. It is available in Microsoft 365 and Excel 2021 or later, and may not be available in older desktop versions. For simple inspection, the built-in table filter is usually more direct.

Frequently Asked Questions

Can I filter an Excel table by clicking a cell?
Yes. Right-click a cell in the data area, then choose Filter > Filter by Selected Cell’s Value when that command is available. Otherwise, use the column dropdown to select the same value.

Does filtering delete rows in Excel?
No. A filter hides rows that do not match the criteria. Clear the filter to show them again; use a delete command only if you truly intend to remove records.

Can I filter a table by more than one value?
Yes. Open the column dropdown, select multiple values in its checklist, and apply the selection. You can also filter other columns to narrow the results further.

How do I remove a filter from just one column?
Open that column’s dropdown and choose Clear Filter From and the column name. Filters on other columns can remain in place.

Why can’t I find Filter by Selected Cell’s Value?
The command may not be available in the context menu in your Excel version or where filtering is not enabled. Turn on filtering with Data > Filter, or use the column dropdown to select the value directly.

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.