You turn on a filter in Excel, but the arrows disappear, rows stay hidden, new data gets ignored, or the menu shows the wrong filter type. Most filter problems come from old criteria, a broken data range, mixed data types, protection settings, or the wrong filtering tool for the job. Start with the quick reset, then move through the range, data, and workbook checks in order.
1. Reset the filter arrows first
Start here when the filter arrows are missing, the drop-down list looks wrong, or hidden rows stay hidden after you change a filter.
- 1.Select any cell inside the range or table.
- 2.Go to Data and select Filter to remove the arrows and show all data.
- 3.Select Data and Filter again to turn the arrows back on.
- 4.Open a column header arrow, choose Text Filters, Number Filters, or another available filter type, enter the criteria, then select OK.
To clear filters while keeping the arrows, use Data and Clear. The other path is Home, Sort & Filter, and Clear. To clear one column only, open that column's filter button and choose Clear Filter from the column name.
For the keyboard route, select the cells you want to filter and press Ctrl+Shift+L. In Excel for Windows, press Alt+Down Arrow to open the selected column's filter menu, use Spacebar to clear or select values, then press Enter.
2. Select the exact range Excel should filter
Excel filters the related data range it detects. Blank rows or blank columns inside that range split the list, so remove those blank rows or columns, select the full intended range, then use Data and Filter again.
Keep unrelated worksheet content outside the filtered list. Leave at least one blank column and one blank row between the list and other data on the sheet, then select the intended range before applying Data and Filter.
Check the headers before you blame Excel. For a normal range, select the data and make sure each column has a heading before choosing Data and Filter. For a table, use Home, Format as Table, pick a style, set My table has headers correctly, then select OK.
3. Turn a growing list into a table
- 1.Select a cell in the list, or select the full range.
- 2.Go to Home and choose Format as Table.
- 3.Choose a table style.
- 4.In Format as Table, select My table has headers when the first row contains column names.
- 5.Select OK.
Excel tables have filter buttons in the header row by default, which makes them a better fit for lists that gain new rows. Tables also help when one worksheet holds separate datasets: Excel applies AutoFilter to only one range of cells on a sheet at a time, so convert each dataset to a table or move one dataset to another worksheet.
4. Refresh filters after edits
If the filter worked earlier and now ignores new or changed rows, reapply the existing filter. Use Home, Sort & Filter, and Reapply.
Use this after adding rows, deleting rows, editing values, or recalculating formulas. It refreshes the current filter and sort conditions without rebuilding them.
5. Convert text numbers and text dates
A filtered column should keep the same kind of data from top to bottom. When one column mixes numbers, dates, and text, Excel offers one filter command type for that column based on the most common data type. That is why a price column shows Text Filters instead of Number Filters, or date filters fail to behave like date filters.
- 1.For numbers stored as text, insert a new column next to the problem column.
- 2.Enter a VALUE formula that references the first text-number cell, then fill the formula down.
- 3.Select the new formula cells and press Ctrl+C.
- 4.Select the first original cell, then use Home, Paste, Paste Special, and Values. In supported Excel versions, Ctrl+Shift+V also pastes values.
For dates stored as text, select a blank cell with the General format, enter a DATEVALUE formula that references the text date, fill down, copy the results, then paste them over the original dates with Paste Special and Values. Apply a date format afterward so the converted values display as dates.
6. Unblock protected sheets and shared views
A protected worksheet changes what users can do with filters. If you own the sheet, go to Review and Protect Sheet, then allow Use AutoFilter before protecting it. To add or remove AutoFilter on a protected worksheet, unprotect the sheet first.
When someone else's sorting or filtering keeps changing a shared workbook view, use View, Sheet View, and New in a workbook stored in OneDrive or SharePoint. Sheet View is grayed out on a local copy, so save or move the file to OneDrive or SharePoint first. Apply the sort or filter you need. To save it, open the Sheet View menu, select Temporary View, type a name, and press Enter. To leave the view, use View, Sheet View, and Exit.
Skip older instructions that tell you to use Review and Share Workbook. Microsoft describes Shared Workbooks as an older feature replaced by co-authoring, so use OneDrive or SharePoint co-authoring with Sheet View instead.
7. Pick the matching filter tool
If the problem is inside a PivotTable, use the PivotTable filter menu. Select the PivotTable filter drop-down arrow, choose Label Filters or Values Filters, or clear Select All, select the row or column labels you want, then choose OK.
If a slicer controls the table or PivotTable, clear it from the slicer itself. Select Clear Filter in the slicer. To delete the slicer, select it and press Delete, or right-click it and choose Remove followed by the slicer name.
For data loaded through Power Query, edit the filter in Power Query. Select a cell in the loaded query data, open Query, choose Edit, then use the column's down arrow in Power Query Editor to choose Text Filters, Number Filters, Date/Time Filters, or Clear filter.
For large columns where the drop-down list does not show every value, use the filter menu's Search box or a custom Text Filters, Number Filters, or Date Filters condition. Excel shows only the first 10,000 unique entries in the filter window.
For more complex criteria, create a criteria range with matching labels, click a cell in the list range, then use Data and Advanced. Choose Filter the list, in-place or Copy to another location, enter the List range and Criteria range, then select OK. Advanced Filter does not auto-update when criteria values change.
8. Escalate to Excel and workbook repairs
When filters fail only in one workbook, treat that file differently from Excel itself. Open File, choose Open, select the workbook, select the arrow next to Open, choose Open and Repair, then select Repair. If repair fails, choose Extract Data.
- Disable Excel add-ins from File, Options, Add-ins, choose Excel Add-ins next to Manage, select Go, clear the add-in checkbox, then confirm. For COM add-ins, choose COM Add-ins, select Go, clear the checkbox, then select OK.
- Check disabled startup items on Windows from File, Options, Add-ins, Manage, Disabled Items, and Go.
- Update Excel on Windows from File, Account, Product Information, Update Options, and Update Now. If Update Now is missing, choose Enable Updates first.
- Update Excel on Mac from any Office app with Help, Check for Updates, then Update or Update All in Microsoft AutoUpdate.
- Repair Microsoft 365 or Office on Windows 11 from Start, Installed apps, your Microsoft 365 or Office product, the ellipses menu, and Modify; on Windows 10, use Start, Apps and Features, your product, and Modify. For Click-to-Run installs choose Online Repair and Repair; for MSI-based installs choose Repair and Continue.
On a work or school device, updates and add-in security settings can be managed by the organization. If File and Account shows no Update Options and only About, use Microsoft Update or contact the help desk. Add-in security controls under File, Options, Trust Center, Trust Center Settings, and Add-ins can also be locked by policy.
Frequently Asked Questions
Why is Excel showing Text Filters instead of Number Filters?
Excel is reading the column as text because the column contains text-stored numbers or mixed data types. Convert the values with VALUE, paste the results back as values, then apply the filter again.
Why are some values missing from the filter drop-down list?
Excel shows only the first 10,000 unique entries in the filter window. Use the Search box or a custom Text, Number, or Date filter to target values that are not visible in the list.
Can I filter two separate ranges on the same worksheet?
AutoFilter applies to only one range of cells per sheet at a time. Convert each dataset to a table with Home > Format as Table, or move one dataset to another worksheet.
What shortcut turns filters on or off in Excel?
Select the cells you want to filter and press Ctrl+Shift+L. In Excel for Windows, Alt+Down Arrow opens the selected column's filter menu.
Why does my filter change when someone else sorts the shared file?
Use Sheet View. Go to View > Sheet View > New, apply your filter, then save the temporary view with a name if you want to reuse it.
