Excel filter not working: how to fix it on Windows 11

Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows 11, the versions Microsoft lists on its Use AutoFilter to filter your data page. Menu names below are from Excel for Windows; Excel for Mac and Excel for the web place some commands differently.

Match your symptom

The table is a map of this guide, not a list from Microsoft.

What you see	Likely cause	Go to
New rows at the bottom aren’t filtered	Rows added below a blank row, or after the filter was set	Fix 1, Fix 2, Fix 3
Filter stops partway down the sheet	A blank row or column splits the data	Fix 2
Some numbers or dates are missing from the list	Values stored as text, or mixed types in one column	Fix 4
Results look wrong or rows stay visible	Merged cells, or rows hidden by hand	Fix 5
Filter button grayed out	Grouped sheets or a protected sheet	Fix 6
The value you need isn’t in the drop-down	Long list of unique entries	Fix 7

How an Excel filter picks its rows

Microsoft’s Filter data in a range or table page describes the basic steps for a range: select any cell in it, go to the Data tab and select Filter, then use the arrow in a column header. Its AutoFilter page adds that entire rows are hidden when values in one or more columns don’t meet the criteria.

The part that causes trouble is the phrase “any cell in the range”. As general guidance, when you select a single cell, Excel works out the range itself by looking for the block of filled cells around it, and it stops at the first completely empty row or column. Anything past that gap sits outside the filter, so it never hides and never shows up in the drop-down. Tables work differently: Microsoft says tables add filter controls to their headers automatically, and the table’s own size sets which rows are included.

Fix 1: Clear the filter and apply it again

Microsoft notes that you can reapply a filter to refresh its results or clear it to show all the data again. A filter doesn’t update itself when you edit or add values, so rows you changed after filtering can stay visible even though they no longer match. As general guidance on where the commands sit in Excel for Windows:

1. Select any cell in the filtered data.
2. On the Data tab, in the Sort & Filter group, select Reapply to run the same criteria on the current values.
3. If the results still look wrong, select Clear in the same group to show every row, then set the criteria again.

To remove the filter arrows completely and start fresh, select Filter on the Data tab again, or press Ctrl + Shift + L. This doesn’t delete any data; it only shows hidden rows and removes the arrows.

Fix 2: Select the whole range before filtering

Microsoft’s AutoFilter steps begin with selecting the data you want to filter. Doing that yourself, rather than letting Excel guess, avoids the blank-row problem described above:

1. Turn off the current filter with Data > Filter.
2. Select the header row and every row of data below it, including any rows after a gap. Select whole columns if the data keeps growing.
3. Select Data > Filter again and check that the header arrows sit on the right row.

A cleaner long-term fix, as general guidance, is to delete blank rows and columns inside the data, or fill them with a placeholder such as a dash. Keep exactly one header row on top: a title or a second header row above it can make Excel put the arrows on the wrong row.

Fix 3: Turn the range into a table

If you add rows often, a table saves you from redoing Fix 2 each time. As Microsoft’s filter page explains, tables come with filter controls in the header automatically. As general guidance, a table also grows when you type directly below it, so new rows land inside the filter.

1. Select any cell in the data and press Ctrl + T, or go to Insert > Table.
2. Check that the range shown covers all your rows, and keep My table has headers selected.
3. Select OK. Each header now has its own filter arrow.

A table changes how the sheet looks and how formulas can refer to it. If other workbooks or macros depend on exact cell addresses, test on a copy first. When you rearrange rows later, our guide on how to move a row in Excel covers moving them without overwriting data.

Fix 4: Make each column one data type

Microsoft’s filter page shows Text Filters and Number Filters as separate menus. As general guidance, Excel offers one or the other, and groups dates by year and month, based on what a column mostly contains. Numbers or dates stored as text break that: they fall outside a number or date filter, appear as a separate group, or sort in an odd order.

Signs of values stored as text, as general guidance:

• Numbers aligned to the left of the cell while real numbers align right.
• A small green triangle in the cell corner, with a warning that the number is stored as text.
• Dates that don’t group under years in the filter list, or show as plain text entries.

To convert them, select the column, select the warning icon and choose Convert to Number, or use Data > Text to Columns and select Finish to make Excel re-read the values. Data pasted from websites or exported from other systems can also carry extra spaces, which make two entries that look the same appear twice in the list. The TRIM function in a helper column removes them. If formulas then return stale results, see Excel formulas not calculating or updating.

Fix 5: Unmerge cells and check hidden rows

Merged cells keep their value only in the top-left cell, so as general guidance, a filter treats the other rows of a merged block as empty and may hide or show them in ways that look random. To check, select the data and open Home > Merge & Center; if cells are merged, select it again to unmerge, then fill in the empty cells. Center Across Selection in the cell alignment settings gives a similar look without merging.

Rows you hid by hand with Hide are a separate matter from rows a filter hides. As general guidance, clearing a filter won’t show rows hidden manually, so they can look like data the filter missed. Select the whole sheet, right-click a row number and choose Unhide to bring them back.

Fix 6: Ungroup sheets and check protection

When the Filter button is grayed out, check the state of the workbook rather than the data. The checks below are general guidance:

• Grouped sheets: if the title bar shows Group after the file name, more than one sheet tab is selected and filtering isn’t available. Right-click a sheet tab and choose Ungroup Sheets.
• Protected sheet: on a protected sheet, filtering works only if the person who protected it allowed it. If you know the password, use Review > Unprotect Sheet. When protecting a sheet yourself, select Use AutoFilter in the list of allowed actions; the arrows have to be in place before you protect it.
• Read-only or locked file: a workbook opened in Protected View or as read-only may block changes until you enable editing. If Excel says another person has it open, see Excel file is locked for editing by another user.

On a work file, ask the owner before removing protection. It may be there to stop accidental changes to shared data.

Fix 7: Search the filter list instead of scrolling

Microsoft’s AutoFilter page describes two ways to choose values from the header arrow, plus wildcards for the search:

• Choose specific values: clear (Select All), then check only the values you want to see.
• Search: type the text or numbers you’re looking for in the Search box.
• Wildcards: a question mark (?) stands for any single character and an asterisk (*) for a series of characters.

As general guidance, the drop-down has a cap on how many unique entries it can list, so in a large column a value can seem to be missing when it’s only past that limit. Typing it in the Search box, or using a Text Filters or Number Filters condition such as Contains or Between, reaches it anyway.

If the filter list takes a long time to open, or Excel freezes while filtering a very large sheet, our guide to Excel not responding covers add-ins, graphics drivers and other causes of hangs.

Fix 8: Update or repair Office

If filters fail in every workbook, including a new one with a few rows of test data, the data isn’t the cause. As general guidance, install the latest updates with File > Account > Update Options > Update Now and restart Excel. If your organization manages updates, that button may be hidden or locked.

When a fresh, simple workbook still won’t filter on a current build, a damaged installation is possible. Our guide on how to repair Microsoft Office explains Quick Repair and Online Repair.

Known issues

As of November 2026, Microsoft’s Fixes or workarounds for recent issues in Excel for Windows page, last updated in September 2026, lists no issue about filtering, AutoFilter, sorting or tables. Check that page again if filters stop working right after an Office update, since Microsoft adds issues as they’re confirmed.

Related guides

• Excel formulas not calculating or updating: how to fix it
• Excel not responding: how to fix freezes and hangs
• Excel file is locked for editing by another user: how to fix it
• How to move a row in Excel (without overwriting data)
• How to repair Microsoft Office (Quick Repair and Online Repair)

Official sources

• Microsoft: Filter data in a range or table in Excel
• Microsoft: Use AutoFilter to filter your data
• Microsoft: Fixes or workarounds for recent issues in Excel for Windows