Excel Filter Dropdown Not Working? Fix Common Causes

If an Excel filter dropdown is missing, will not open, or shows the wrong results, first select a cell in the data and choose Data > Filter to turn AutoFilter on; then check that the filter covers one continuous range with a single header row. Most problems come from an incorrect range, an active filter criterion, or worksheet protection—not from a broken workbook.

What an Excel filter dropdown does

Excel’s AutoFilter adds a dropdown arrow to each column heading in a selected data range. You can use the arrow to show particular values, sort records, or set conditions such as dates before a given day or text that contains a word. Filtering hides rows that do not meet the chosen criteria; it does not delete those records.

AutoFilter is different from a dropdown list used to enter data. A filter menu appears in a column heading and controls which rows are visible. A data-validation list appears when you select an input cell and offers choices for that cell. If you mean the latter, check Data > Data Validation rather than the filter controls.

In Microsoft 365 for Windows, the main controls are on the Data tab, in the Sort & Filter group. A filter can also be toggled with Ctrl+Shift+L. On Mac, use Data > Filter; keyboard shortcuts can vary with the Excel release and macOS settings, so the ribbon command is the dependable option. Excel for the web also has filtering commands on the Data tab, though the available interface can differ slightly.

Turn the filter back on and clear old criteria

If the arrows have disappeared, click inside the data and choose Data > Filter. If that does not restore the arrows, select the full dataset—including its headings—before choosing the command. Pressing Ctrl+Shift+L on Windows toggles AutoFilter, so pressing it accidentally a second time can remove the arrows. Use the ribbon to confirm the current state.

If arrows are present but the expected rows are absent, clear the criteria before changing the data. On the Data tab, choose Clear in the Sort & Filter group to remove active filter and sort criteria. You can also open an individual column menu and choose Clear Filter From [column name]. The wording may vary slightly by build. A funnel icon on a heading indicates that a filter is active; a plain dropdown arrow does not.

Clearing a filter reveals rows hidden by that filter, but it does not necessarily reveal rows hidden manually. If row numbers skip—for example, the sheet goes from row 12 to row 18—select the surrounding rows, right-click, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Rows. This distinction matters when a filter seems to have returned only some records.

Check the selected range and its headers

AutoFilter works best with a rectangular block of data: one header row followed by records, with each field in its own column. Click inside the block and inspect which headings receive arrows. If only some columns have arrows, Excel may have applied the filter to only part of the data. Select the entire block, including all headings and records, and choose Data > Filter again.

Blank rows and blank columns can make Excel interpret the data as separate regions. For example, a blank row between two batches of orders can cause a filter started in the first batch to omit the second. Remove unnecessary separator rows or select the full range explicitly before applying the filter. A completely blank row inside a dataset can also be hidden or displayed in ways that make the results seem incomplete.

Use one clear header row, with a distinct label in every column. Avoid merged cells in the header or data area: merged cells can interfere with sorting and filtering because they do not form a regular table structure. Unmerge them, fill in the necessary values, and keep each record on one row. If the first row is actually a title, select the row containing the real field names as the header instead.

When data is added below a filtered range, the new records may fall outside that range. Reapply the filter to the expanded selection, or convert the block to an Excel table so added rows are included more reliably. Check that the range includes the final record, not just the first screen of visible data.

Look for criteria and data-format differences

A filter can be working correctly while appearing to omit values. Open the column menu and inspect the checked items. If only a few values are selected, choose Select All, then select the intended values. For a quick reset across the whole sheet, use Data > Clear. Remember that filters in different columns combine: a status filter for Open and a region filter for West show only rows meeting both conditions.

Values that look alike may not be identical to Excel. A cell containing West with a trailing space is different from West without one. Similarly, numbers stored as text may behave differently from numeric values, and dates imported as text may not appear under the date-filter options you expect. Inspect a few source cells, check their alignment and number format, and test the filter using the exact value shown in the menu.

Dates can be especially confusing when a column mixes real Excel dates with text, blanks, or errors. A real date is stored as a serial number and displayed using a date format; text that resembles a date is not necessarily recognized as one. If the menu groups dates into years and months but some entries appear separately, check the underlying values and correct inconsistent imports before relying on the filter.

Also check for errors and blank cells. Depending on the column, the menu may list (Blanks), error values, or many individual entries. If a record is not visible, clear all criteria first and then search the relevant column’s menu. Filtering is not a substitute for checking whether the record actually exists in the selected range.

Fix a dropdown that will not open

If the arrow is visible but clicking it does nothing, first click another cell and try again. Press Esc to close any open edit mode, dialog, or menu, then retry. Make sure the worksheet is not protected in a way that prevents filtering. On the Review tab, look for Unprotect Sheet; if you do not have the password or permission, ask the workbook owner rather than trying to bypass protection.

A protected sheet can allow filtering only if the protection settings permit it. The person protecting the sheet can review Review > Protect Sheet and allow Use AutoFilter. In some cases, that permission must be enabled when protection is applied. Unprotecting and reprotecting a shared or controlled workbook should be done only with the owner’s approval, since protection may preserve intended editing limits.

Check whether multiple worksheet tabs are grouped. When several tabs are selected together, some commands behave differently. Right-click a selected sheet tab and choose Ungroup Sheets, then try the filter again. If the workbook is in a dialog, cell-edit mode, or another interface state, finish or cancel that action before testing the dropdown.

If the problem appears limited to one workbook, save a copy and reopen it. If possible, compare the same data in a new workbook to see whether the issue follows the file or the Excel session. For a shared workbook, confirm that you have editing access and that another user has not changed the range or protection settings. Avoid deleting rows or rebuilding the data until you know whether the issue is only a filter setting.

Use an Excel table for changing datasets

For an ordinary list that grows over time, converting the range to a table often prevents range-boundary mistakes. Select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that My table has headers is selected if the first row contains field names. Excel tables include filter dropdowns in their headings and usually expand when you type or paste a new row directly beneath them.

Tables are useful when you add records regularly, but they do not fix inconsistent source data or every protection issue. A table can still have filters that hide rows, and its headings should still be unique and meaningful. If you need to return to a plain range, select a table cell and use Table Design > Convert to Range; the exact tab can appear only while a table cell is selected.

Do not create a second filter over the same table just because a dropdown looks unfamiliar. Check the table’s filter menu and the Table Design tab first. If you have separate blocks of data on one sheet, consider making each block its own table rather than relying on blank rows to separate one large filter range.

A quick troubleshooting sequence

Use this sequence to narrow down the cause without changing the underlying records:

Click inside the dataset and check whether the dropdown arrows appear on every intended heading.
Choose Data > Clear, then confirm whether the missing rows return.
Select the complete rectangular range, including the real header row, and choose Data > Filter.
Check for blank separator rows, merged cells, duplicate or empty headings, and records below the selected range.
Inspect filter selections for the relevant columns and check whether hidden rows remain hidden manually.
Review Review > Unprotect Sheet and confirm whether sheet protection permits AutoFilter.
Save a copy, reopen the file, and compare with a new workbook if the dropdown still will not respond.

This order separates a display or range issue from a data issue. For example, if Data > Clear restores the missing orders, the range was likely fine and a criterion was excluding them. If arrows appear only after you select the full block, the original filter covered too little data. If neither change helps and the sheet is protected, permissions are a more likely explanation.

Frequently Asked Questions

Why is the filter arrow missing in Excel?
Select the data, including its header row, and choose Data > Filter. If arrows still appear on only some headings, reselect the complete range and check for blank rows or columns that split the data into separate blocks.

How do I show all rows again?
Choose Data > Clear to remove filter criteria. If some row numbers are still missing, those rows may be hidden manually; select the neighboring row numbers, right-click, and choose Unhide.

Why does my filter not include new rows?
The new rows may be outside the range to which AutoFilter was applied. Reapply the filter to the expanded range or convert the data to a table, which is designed to expand as records are added below it.

Why can I not click the filter dropdown?
Check whether the sheet is protected and whether the protection allows AutoFilter. Also exit cell-edit mode or any open dialog, and ungroup worksheet tabs if several sheets are selected. If you lack permission to change protection, contact the workbook owner.

Why are some values missing from the filter list?
First clear other column filters, since criteria in separate columns combine. Then check whether the range includes those records and whether the values contain extra spaces, text-formatted numbers, text dates, blanks, or errors.

Keep the data easy to filter

A dependable filter starts with a consistent structure: one header row, one record per row, no merged cells, and no blank separator rows inside the list. Keep fields consistent—for example, enter dates as actual dates and avoid mixing numbers with text in the same column. When records are added often, an Excel table makes it easier for filter controls to cover the expanding dataset.

Most filter-dropdown problems can be fixed by restoring AutoFilter, clearing criteria, selecting the full range, or reviewing sheet protection. Since filtering hides rather than removes rows, the underlying records are usually still present. Clear criteria and check hidden rows before concluding that data has been lost.

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.