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

To filter an Excel table by value in Microsoft Excel for Microsoft 365 on Windows, click the arrow in the relevant column header, clear Select All, select the value or values you want to keep, and click OK. Excel hides rows that do not match; it does not delete them.

Quick steps for filtering a table

Excel tables normally show a filter arrow in every header cell. If your data is already formatted as a table, you can apply a basic value filter without selecting the data or opening a separate dialog. For example, if a table has a Region column containing East, West, and Central, choosing only West displays the rows whose Region value is West.

Click the filter arrow in the header of the column you want to filter.
In the menu, clear Select All. This removes the checkmarks from the listed values.
Select the value or values to display. Use the search box in the menu to find a value in a long list.
Click OK. The table displays matching rows and marks the filtered column with a filter icon.

To show all rows again, open that column menu and choose Clear Filter From followed by the column name. If filters are active in several columns, clearing one column leaves the other filters in place.

What filtering by value does

A filter changes which rows are currently visible; it does not rearrange the underlying data permanently, remove records, or change cell values. Excel keeps the rows in the worksheet, but hides rows that fail the selected condition. Clearing the filter makes those rows visible again. This is useful for examining a subset of a larger list while retaining the complete table for later analysis.

Filtering is different from sorting. Sorting changes the order of visible records, while filtering narrows the display to records that meet a condition. You can use both together: for instance, filter a sales table to show one region, then sort the remaining visible sales from largest to smallest.

When you select values in a column menu, Excel builds the list from values in that column. A checkmark means that value is included. A cleared box means rows with that value are excluded. The list may show a value only once even when many table rows contain it; selecting it includes all matching rows, not just one occurrence.

Choose specific values from the filter menu

Selecting one or more listed values is the simplest way to filter categories, names, locations, or status labels. Suppose a table has a Status column with Open, Pending, and Closed. To review unfinished work, select Open and Pending and leave Closed unchecked. Excel treats the selected values in one column as alternatives: a row is kept if its Status is Open or Pending.

For large lists, type part of the value into the search box in the filter menu. The displayed checklist narrows to matching entries, making it easier to locate an item such as a product code or customer name. Select the intended result and click OK. Search helps you find a value; it does not itself apply a filter until you confirm the selection.

To show one category, select just that category.
To show several categories, select each required value before clicking OK.
To include every listed value again, select Select All or clear the filter.

Be careful when a value is not visible in the checklist. The list may be scrolled, narrowed by a previous filter in another column, or limited by the search text. Clear the search box and check whether another column is filtering out the rows that contain the value.

Use text, number, and date criteria

A checklist works well when you know the exact values. For ranges, partial matches, or comparisons, use the filter options that match the column’s data type. Open the header arrow and look for Text Filters, Number Filters, or Date Filters. The available menu depends on the values Excel recognizes in that column.

Text: Text Filters can find entries that contain, begin with, or end with specified characters, as well as entries equal to or not equal to text. A Contains condition can find product descriptions containing the word cable even when the full descriptions differ.
Numbers: Number Filters include comparisons such as greater than, less than, between, and equal to. For example, use Greater Than to display amounts above a chosen threshold rather than selecting every individual amount from a checklist.
Dates: Date Filters can provide calendar-based choices such as a date range or a period such as a month or year. Excel may group dates into a hierarchy, which is convenient for broad periods but can be confusing if the cells contain text that only looks like a date.

Filter menus can also offer conditions such as Above Average for numbers or This Week for dates, depending on the data and Excel version. Read the condition carefully before confirming it. A date displayed as 1/2/2026 can mean January 2 or February 1 depending on regional settings, so verify the actual date interpretation when filtering imported data.

Combine filters across columns

Filters on different columns are combined. If you select Region = West and Status = Open, Excel displays rows satisfying both conditions: the row must be in the West region and have an Open status. Applying a second column’s filter does not normally replace the first one. The filter icons and the hidden rows reflect the combined result.

Within a single column, selecting several checklist values usually means one value or another. For example, selecting West and Central in Region displays either region. A custom filter can also combine two conditions within one column. In a text or number filter dialog, choosing the And option requires both conditions to be true; choosing Or displays rows that meet either condition. This distinction matters when setting a range: a number greater than 10 and less than 20 describes values between those limits, while greater than 10 or less than 20 would include nearly every number.

Think of each column filter as narrowing the current result. If a row disappears unexpectedly, inspect all filtered columns, not only the one you just changed. One active condition elsewhere in the table may be excluding it.

Find the filter controls and use shortcuts

Tables created with Excel’s Table feature ordinarily include header filter buttons. If the arrows are missing, click inside the table and check the Table Design tab for the Filter Button option in Table Style Options. The tab appears when a table cell is selected. If the data is a plain range rather than a table, select a cell in the range and use Data > Filter to turn AutoFilter on. For a new table, use Insert > Table and confirm whether the data has headers.

On Windows, Ctrl+Shift+L toggles filter buttons for the selected data range or table. On Mac, Command+Shift+F is the commonly used equivalent in Excel; shortcut behavior can depend on the keyboard and Excel version. If a shortcut does not work, use the ribbon command. In Excel for the web, the table filter arrows are also available, though the interface and some options can differ from desktop Excel.

When the header row itself is not recognized correctly, Excel may treat the first data row as headers or include a blank header. Check that each column has one unique, nonblank heading and that the table begins on the intended row. Correcting the table structure is often more effective than trying to filter around a misidentified header.

Common filtering problems and fixes

The value is missing from the list: Clear the menu search, scroll the list, and inspect other active filters. Also check whether the records containing that value are actually inside the table range.
Similar values appear separately: Extra spaces, different punctuation, or inconsistent spelling can create distinct entries, such as West and West with a trailing space. Clean or standardize the source data if the entries should be treated as one category.
Numbers behave like text: Imported values may be stored as text. They can sort or filter differently from numeric cells, and Number Filters may not be available as expected. Check the cell alignment and number format, then convert the source values to actual numbers if appropriate.
Dates do not filter as expected: Some cells may contain text rather than real Excel dates, or regional date formats may have been interpreted differently. Confirm the underlying values and make the column consistent before relying on date criteria.
Rows seem to have vanished: They are usually hidden by a filter rather than deleted. Use Data > Clear to clear active filters across the data, or clear the relevant column individually. Also check for manually hidden rows if clearing filters does not restore the records.
New records do not appear in the results: If the data is an Excel table, adding data immediately below it normally expands the table. If it is a plain range, the new rows may lie outside the filtered range; expand or recreate the range before filtering.

Filtering does not make excluded records safe to delete or invisible to every Excel feature. Hidden rows remain part of the workbook, and formulas or summaries may treat filtered data differently depending on the function used. If you plan to copy only the visible results, check the selection before pasting so hidden records are not unintentionally included.

Filtering compared with other ways to narrow data

Use a table’s built-in filter when you want an interactive, temporary view of existing records. It is quick to operate, preserves the source rows, and is a good fit for browsing, checking a category, or preparing a focused view for a colleague. It is not a separate report: the table itself is still the same data, with some rows hidden.

For a repeatable report that updates in a separate area, a formula-based result may be more suitable. The FILTER function is available in Microsoft 365 and Excel 2021 or later, but it creates a spilled result rather than hiding rows in the original table. For grouping and summarizing records, a PivotTable may be more useful than manually selecting checklist values. These are alternatives for different goals, not replacements required for ordinary table filtering.

Excel’s filter menu may also provide filtering by cell color or font color when the column contains formatting. That is different from filtering by the underlying value: two cells with the same text could have different colors, and color filtering depends on formatting being applied consistently. If the color represents a meaningful status, a dedicated Status column is usually clearer and easier to maintain.

Frequently Asked Questions

How do I filter an Excel table to show one value only?
Click that column’s header arrow, clear Select All, select the value, and click OK. Excel hides the table rows whose entries in that column do not match.

Can I select more than one value in a table filter?
Yes. Open the column menu, clear Select All, select each value to include, and click OK. The table displays rows matching any of those selected values in that column.

How do I filter for values greater than a number?
Open the number column’s filter arrow, choose Number Filters > Greater Than, enter the threshold, and confirm. Excel shows rows with numeric values above that threshold.

How do I remove a filter without deleting data?
Open the filtered column’s menu and choose Clear Filter From that column. To clear all active filters, use Data > Clear. Both actions reveal rows again; they do not delete the records.

Why does my table have no filter arrows?
Confirm that the data is an Excel table and that its filter buttons are enabled in Table Design > Table Style Options > Filter Button. For a plain range, click inside it and choose Data > Filter.

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.