Excel Table Filter Not Working? Fixes to Try

If an Excel table filter is not working, click its drop-down arrow and choose Clear Filter From [column], then select the values you want to show. If the arrows are missing or the rows do not change, check that you are working inside the table, that the filter covers the right data, and that the worksheet is not blocking filter use.

How Excel table filters work

An Excel table stores related records in rows, with a header for each column. Its filter arrows let you show only rows that meet selected conditions. Choosing a value in one column hides rows that do not match; choosing criteria in another column narrows the visible results further. Criteria across different columns therefore work together, while selecting several values within one column generally shows rows matching any of those selected values.

Filtering hides rows temporarily; it does not delete records or change their underlying values. That distinction matters when a total or count seems to change: functions such as SUBTOTAL can calculate using visible rows only, while a normal SUM may still include filtered-out rows. A filtered table can also look empty even though its records remain in the worksheet.

Tables usually display filter arrows in their header row. If you have a normal cell range rather than a table, Excel can filter that range too, but the range and its headers must be identified correctly. A PivotTable has its own field filters and behaves differently from a regular Excel table.

Start with these quick checks

Work through the simplest explanations before changing the workbook structure. A filter that looks broken is often still active with an unexpected selection, or it is acting on a smaller range than the user expects.

Look for a filter icon. In a filtered column, the header arrow may show a funnel rather than the usual drop-down arrow. Open it and check which values or conditions are selected.
Clear the current condition. In the affected column menu, choose Clear Filter From [column name]. This removes that column’s condition without changing the records.
Check other columns. A second filter can continue to hide rows after you clear the first one. Open each header menu and inspect its selections.
Check the table header. Click a cell in the table and look for the contextual Table Design tab. If it appears, Excel recognizes the selection as part of a table.
Reapply the filter. If the table’s values changed after filtering, use Data > Sort & Filter > Reapply. This asks Excel to apply the current filter and sort settings to the updated data.

When the table has no matching records, Excel may display a blank data area beneath the headers. That does not necessarily mean the filter is malfunctioning: check whether the selected values actually occur in the table, and clear all active conditions before concluding that rows are missing.

Check that the filter covers the complete table

A common cause is a row or column that looks like part of the data but sits outside the table. This can happen when records are pasted below the last table row, when a blank row separates a new batch, or when an extra field is entered beyond the table’s right edge. Filtering the table will not necessarily include data that Excel has not added to it.

Click inside the table and inspect its outline. If the intended records fall outside it, select a table cell, open Table Design, and choose Resize Table. In the dialog, set the range to include the header row and all intended records, then confirm. Take care not to include a separate summary row or unrelated data: those rows may then be treated as ordinary records.

For a short addition, typing directly into the first row immediately below a table often expands it. Pasting a block is less predictable, especially if there is a blank row or adjacent content, so verify that the table border moves to include the new records. A useful test is to click one of the added cells and see whether Table Design appears. If it does not, the cell may not belong to the table.

Also check that the first row is truly a header row. A title above the data, a blank line, or a multirow heading can cause Excel to interpret the range incorrectly when you turn on filtering. Tables use one header row, and their column names need to identify the fields. If you have a title, keep it above the table rather than including it as a data header.

Inspect headers, blanks, and inconsistent values

Filter menus are built from the values in a column, so inconsistent data can make the list confusing. For example, a Status column might contain Open, open, and Open followed by a space. These can appear as separate choices even though they look nearly identical. Selecting one spelling will not necessarily show records with the other spelling.

Check for differences such as extra spaces, inconsistent punctuation, mixed date formats, or numbers stored as text. The same issue can affect sorting and numeric or date filters. For example, a date stored as text may not behave like a genuine Excel date, while a text value such as 100 can sort differently from a number with the same digits. Correct the source values if they should represent the same kind of data.

Blank-looking cells can also be misleading. A cell may be truly empty, contain a space, or contain a formula that displays an empty string. These are not necessarily identical to Excel, so the filter menu may offer choices that do not match what your eyes suggest. To diagnose a suspicious column, click a few cells and inspect the formula bar; if needed, clean the source data or replace unintended spaces with genuinely blank cells.

Tables require column headings. If headings are duplicated or blank, Excel may adjust them or supply names when the range becomes a table. Confirm that each field has a clear, distinct header, especially if people will use the filter menus to find a particular column. Avoid merged cells in the header or data area; merged layouts are designed for presentation and can interfere with selecting and managing a consistent record range.

Confirm the filter settings and worksheet permissions

If the arrows are missing, select a cell in the table and check Table Design > Table Style Options > Filter Button. The option controls whether the table displays its filter buttons. A regular range can have filtering switched on from Data > Filter, but first select a cell in the range so Excel can identify the intended data. On Windows, Ctrl+Shift+L toggles filtering for a selected range; it can also turn filtering off, so use it carefully. On Mac, use the Filter command on the Data tab if that shortcut is unavailable or differs in your Excel build.

A protected worksheet may let you view existing filters but prevent you from changing them, depending on the protection settings. Check Review > Unprotect Sheet. If you are authorized to change protection, unprotect the sheet with the required password, adjust the filter, and then protect it again with the needed permissions. When protecting a sheet, the option to use AutoFilter must be allowed if users are expected to operate existing filters while the sheet remains protected. Protection behavior can depend on how the sheet was set up.

Do not confuse a worksheet filter with a hidden row. Someone can hide rows manually, and those rows remain hidden even after a filter is cleared. Select the surrounding row numbers, right-click, and choose Unhide, or use Home > Format > Hide & Unhide > Unhide Rows. If results still seem absent, check for manually hidden rows as well as filter conditions.

Check whether formulas or refreshed data are involved

Filters use the values currently present in the cells. If those values come from formulas and Excel is set to manual calculation, a formula result may be out of date, so the filter can appear to ignore a recent change. On Windows, check Formulas > Calculation Options > Automatic. You can also recalculate with F9. On Mac, check the Calculation options on the Formulas tab; available labels and shortcuts can vary by version.

For a table populated from an external source, a filter cannot display records that have not yet been loaded into the worksheet. Refresh the connection or query using the relevant Data tab command, then inspect the table again. Refreshing can replace or update rows, so consider whether the workbook’s connection settings and intended source are correct before doing so. A filter menu only reflects the data currently available in the table, not every possible record in an external system.

If a column contains formulas that return text, errors, or empty-looking results, inspect a few underlying cells before changing the filter. The visible display is not always the stored value. In a shared workbook, another person may also have changed the source data or applied a different filter view. Check whether the workbook is shared and whether the displayed rows are the ones you expect before editing records.

Know when it is not a table filter

A PivotTable, chart, or slicer can look like a table control but has different rules. PivotTable filters operate on fields in a summarized report, and a slicer is a separate visual control that can filter connected tables or PivotTables. If selecting a value in a slicer does not affect the object you expect, check its report connections rather than the regular table’s header arrows.

Similarly, a worksheet may contain several tables side by side. Each table has its own header filters, and filtering one table does not automatically filter another independent table. If you need a single control to filter multiple related reports, consider whether a PivotTable with a slicer or a properly connected data model is more suitable. Those options involve setup beyond simply turning on a table filter.

For a regular table, avoid applying Data > Filter to a partial selection that excludes records or headers. If you accidentally toggle filtering on a different range, click within the intended table and use its own header arrows. On Excel for the web, the table and filter controls are available in the browser, but ribbon placement and some options can differ from desktop Excel. On Mac, contextual table-tab names and layouts can also vary; check the selected table and its filter controls rather than relying on a Windows-only path.

Frequently Asked Questions

Why does my Excel filter show no results?
One or more active conditions may exclude every row. Clear the filter in each relevant column, then check whether the values you want are actually present and consistently formatted. Also confirm that the table range includes the records.

Why are the filter arrows missing from my table?
Click inside the table and check Table Design > Table Style Options > Filter Button. If it is a normal range, select the range and turn on Data > Filter. A protected sheet or a selection outside the table can also make the controls unavailable.

How do I remove every filter from an Excel table?
Open each filtered column menu and choose Clear Filter From that column, or use Data > Sort & Filter > Clear to clear filter and sort settings for the current data range. Clearing conditions shows the rows again; it does not delete records.

Why is a new row not included in my table filter?
The row may have been pasted outside the table or separated from it by a blank row. Click the new row and check whether Table Design appears. If it is outside the table, use Table Design > Resize Table to include it.

Can I filter a protected Excel sheet?
Often, users can operate existing filters if the sheet was protected with the AutoFilter permission enabled. If changing the filter is blocked, ask the workbook owner to adjust protection settings or provide an authorized, unprotected copy; do not try to bypass an unknown password.

A reliable way to prevent repeat problems

Keep one clear header row, avoid blank rows inside the records, and make each column consistent in data type and spelling. Add new records directly to the table or verify that pasted records become part of it. When a result looks wrong, clear filters column by column, check the table boundary, and inspect actual cell values before rebuilding the table. These checks usually identify whether the issue is a selection, a range, a data-quality problem, or a worksheet permission rather than a failure of Excel’s filter feature.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.