Excel Filter Dropdown Not Working? 11 Fixes That Work

A laptop showing a spreadsheet with a colourful header row and grid — excel filter dropdown not working fix guide
A filter arrow that will not open, or never appears, usually means the data layout or the sheet settings are blocking it.

You click the small arrow in the header row, and nothing happens. Or the arrow is not there at all, or it is greyed out, or it opens but shows no values to choose from. When excel filter dropdown not working stops you sorting through a list, the cause is almost never a broken Excel. It is usually the shape of the data, a setting on the sheet, or a filter that is already on somewhere you cannot see.

Filters in Excel depend on a clean, rectangular block of data with a header row. Blank rows, merged cells, hidden complications, and sheet protection all break that rectangle in different ways. Excel responds by hiding the arrow, greying it out, or showing an empty list, without explaining why. This guide works through the causes in order, from the simplest toggle to the deeper fixes. Nothing here deletes your data, and every fix can be tested on a copy of your workbook first if the file is important.

Table of Contents

  • Why This Error Happens
  • Quick Checks
  • Diagnosing the Problem
  • Fix 1: Turn the Filter Off and On Again on the Right Row
  • Fix 2: Remove Blank Rows and Columns That Break the Range
  • Fix 3: Unmerge Merged Cells in the Header Row
  • Fix 4: Unprotect the Sheet and Check Workbook Protection
  • Fix 5: Convert the Range to an Excel Table
  • Fix 6: Clear Existing Filters and Check for Hidden Rows
  • Fix 7: Check Grouped Sheets, Shared Workbooks, and the Active Cell
  • Fix 8: Check Frozen Panes, Zoom, and the Arrow Position
  • Fix 9: Disable Add-ins and Test Excel in Safe Mode
  • Fix 10: Check Protected View and File Permissions
  • Fix 11: Repair Office and Move Data to a New Workbook
  • What to Avoid
  • Frequently Asked Questions
  • Conclusion
  • Helpful Official Resources

Why This Error Happens

A filter dropdown is Excel’s way of offering you the distinct values in a column. To build that list, Excel needs to know where the data starts and ends, which row holds the headers, and whether the sheet allows changes. If any of those answers is unclear, the dropdown fails. These are the reasons that break it most often.

1. The Filter Is On, But on the Wrong Row or Range

Excel places filter arrows on the row it thinks is the header row. If the active cell was in the wrong place when the filter was turned on, the arrows can sit on a data row, on an empty row, or on a range that does not include your data. The arrows exist, but they filter the wrong block, so clicking them seems to do nothing useful.

2. Blank Rows or Columns Split the Data

Excel treats a blank row or column as the edge of the data. A single empty row in the middle of a list splits it into two blocks, and the filter only covers the block containing the active cell. The dropdown then shows values from part of the list, or shows nothing, while the rest of the data sits outside the filter range. This is the most common cause of a filter that works “halfway”.

3. Merged Cells in the Header Row Confuse the Filter

A merged header cell spans several columns, so Excel cannot tell which column the arrow belongs to. Merged cells in the header row can hide arrows, grey them out, or make the dropdown show the wrong column’s values. Merged cells anywhere in the data range cause similar trouble, but the header row is where they do the most damage.

4. Sheet Protection or Workbook Protection Blocks Filtering

A protected sheet can block filtering entirely, or allow it only if the protection settings permit it. The filter button greys out, or the dropdown opens but changes nothing. Workbook protection and shared-workbook restrictions can block filtering too. Protection is a deliberate lock, so it gives no error message. It simply refuses.

5. A Filter Is Already Applied, or Rows Are Hidden

If a filter is already applied, the dropdown shows only the values that pass the current filter, which can look like an empty or broken list. Hidden rows, grouped rows, and a filter applied on another sheet in a grouped selection can all make the dropdown behave strangely. The dropdown is working correctly. It is showing you a filtered view of an already filtered list, which is confusing.

6. Add-ins, File Damage, or a Damaged Installation Interfere

Add-ins can intercept clicks, change how the ribbon behaves, or conflict with Excel’s own filter code. A damaged workbook file can carry a corrupt filter definition that Excel cannot render. A damaged Office installation can break the filter feature itself. These causes explain excel filter dropdown not working in every workbook, not just one file, and they need the deeper fixes at the end of this guide.

Quick Checks

Two minutes before the deep fixes.

  • Click a cell inside your data, then look at the Data tab — is the Filter button highlighted, meaning a filter is already on?
  • Look at the header row — are filter arrows visible, missing, or greyed out?
  • Check for a blank row or blank column inside your data — even one empty row splits the range.
  • Look at the header row for merged cells — a header that spans two columns is a merged cell.
  • Check the Review tab — does it say Unprotect Sheet, meaning the sheet is protected?
  • Think about when it started — did excel filter dropdown not working begin after protection was added, data was pasted in, or an add-in was installed?

Diagnosing the Problem

SymptomCauseGo to Fix
No arrows at allFilter off, or on wrong rowFix 1
Arrows cover only part of the listBlank row or column splits rangeFix 2
Arrows missing on some columnsMerged cells in header rowFix 3
Filter button greyed outSheet or workbook protectionFix 4
Dropdown opens but shows no valuesExisting filter or hidden rowsFix 6
Arrows in the wrong placeWrong active cell or grouped sheetsFix 7
Filter fails in every workbookAdd-in or damaged installationFix 9
Filter fails in one file onlyDamaged workbook fileFix 11

Fix 1: Turn the Filter Off and On Again on the Right Row

Start by resetting the filter cleanly, with the active cell in the right place. This fixes the cases where the filter is on but attached to the wrong row or range, and it costs nothing to try.

  1. Click any single cell inside your data block, not on an empty cell outside it.
  2. Go to the Data tab and look at the Filter button. If it is highlighted, a filter is on.
  3. Click Filter once to turn it off. The arrows should disappear from the header row.
  4. Click a cell inside the header row of your data, or any cell inside the data block.
  5. Click Filter again to turn it on. Arrows should appear on the header row.
  6. Click a dropdown arrow and check whether it opens and lists values.
  7. If the arrows appear on the wrong row, turn the filter off, click a cell in the correct header row, and turn it on again.

The active cell matters more than people expect. Excel guesses the data range from the active cell, expanding outward until it hits blank rows or columns. An active cell outside the data, or in a stray block of cells, produces a filter range that does not match your list. Placing the active cell inside the data before turning the filter on is the habit that prevents this.

If the Filter button is greyed out and cannot be clicked at all, do not force it. A greyed-out button means something is blocking filtering, usually protection or a grouped selection, and Fixes 4 and 7 address those. Clicking harder will not help, and the greyed-out state is itself useful information about the cause.

Fix 2: Remove Blank Rows and Columns That Break the Range

A blank row or column inside your data acts as a wall. Excel’s filter stops at the wall, so part of your list is outside the filter range. Removing the blanks, or selecting the range by hand, restores the full list.

  1. Look through your data for any completely blank row or blank column inside the list.
  2. Right-click the row number of a blank row and choose Delete, to remove it entirely. Do not just clear its contents, because the empty row still splits the range if it sits between data.
  3. Do the same for any blank column inside the data.
  4. Click a cell inside the data, turn the filter off and on again, as in Fix 1.
  5. Click a dropdown arrow and check whether it now lists values from the whole list.
  6. If you cannot delete blank rows because they separate sections, select the full range by hand before turning the filter on: click the first header cell, then Shift-click the last data cell.
  7. With the range selected, click Filter on the Data tab. Excel uses your selection instead of guessing.

Blank cells inside a column are fine. A single empty cell in a column of values does not split the range. Only a completely blank row or column, empty across the whole data block, acts as a wall. That distinction matters, because deleting rows with some data in them would lose information. Delete only rows and columns that are entirely empty.

Also check for rows that look blank but contain a space, a formula returning an empty result, or formatting. A cell with a single space in it is not blank to Excel, but it looks blank to you, and it can extend the range in unexpected ways. Click a suspect cell and look at the formula bar. If it shows a space or a formula, clear the cell properly with the Delete key, or fix the formula, before reapplying the filter.

Fix 3: Unmerge Merged Cells in the Header Row

Merged cells are the enemy of filters. A header that spans two columns leaves Excel unsure where the arrow goes, and the filter fails or misbehaves. Unmerging the header row is the fix, and the header text survives in the first cell of the merged range.

A laptop showing a spreadsheet with small dropdown arrows above columns of abstract charts
A merged header spans columns, so Excel cannot tell which column an arrow belongs to. Unmerging restores the arrows.
  1. Select the header row by clicking its row number.
  2. Go to the Home tab and look at the Merge and Centre button. If it is highlighted, the selection contains merged cells.
  3. Click Merge and Centre to unmerge the selected cells. Repeat if the button stays highlighted, which means more merged cells remain.
  4. Alternatively, select the header row, click the arrow next to Merge and Centre, and choose Unmerge Cells.
  5. Check that each header now sits in its own single cell, with its own column.
  6. Turn the filter off and on again, as in Fix 1.
  7. Click each dropdown arrow to confirm it opens and lists that column’s values.

Unmerging keeps the text in the top-left cell of the old merged range and empties the other cells. If a merged header held a title you want centred across columns, use “Centre Across Selection” in the Format Cells alignment options instead of merging. That gives the centred look without merging, and filters keep working. Merging is fine for titles above the data, in a row that is not the header row, but it should never be used inside the header row or the data itself.

Merged cells inside the data range cause similar trouble, though less severe than in the header row. If the header row is clean but the filter still misbehaves, select the whole data range and unmerge it as well. Then reapply the filter. A data range with no merged cells anywhere is the cleanest shape for filtering, sorting, and turning the range into a table, as in Fix 5.

Fix 4: Unprotect the Sheet and Check Workbook Protection

Protection can block filtering silently. The filter button greys out, or the dropdown does nothing. If the sheet is protected, you need to unprotect it, or change the protection settings to allow filtering.

  1. Go to the Review tab and look at the Protect group.
  2. If the button says Unprotect Sheet, the sheet is protected. Click it.
  3. If a password box appears, enter the password. If you do not know the password, ask the person who protected the sheet. Do not use password-cracking tools.
  4. After unprotecting, try the filter dropdown again.
  5. If you need the sheet to stay protected, click Protect Sheet again, and in the options list, tick “Use AutoFilter”. Then set the password again if you use one.
  6. Check workbook protection too: on the Review tab, look for Protect Workbook. If the workbook structure is protected, unprotect it to test, then re-protect it if needed.
  7. If the workbook is shared or stored in a shared location with restricted permissions, check that you have edit permission, not view-only access.

The “Use AutoFilter” permission is the key detail. A protected sheet can allow filtering while still blocking edits, but only if that box is ticked when protection is applied. Many protected sheets were set up without it, because the person who protected the sheet did not think about filtering. Re-protecting with the box ticked gives you both: protection and working filters.

If you do not know the password and cannot ask the owner, you cannot unprotect the sheet through Excel’s own settings, and that is by design. Do not use tools that claim to strip Excel passwords. They are unreliable, they can damage the file, and using them on a file you do not own raises obvious problems. Copy the visible data to a new workbook by hand if you have legitimate access to view it, and build your filter there. For files that will not open at all, our guide to Excel file not opening covers file access problems.

Fix 5: Convert the Range to an Excel Table

An Excel Table is a structured range with built-in filter arrows, automatic range expansion, and consistent formatting. Converting a messy range to a Table fixes many filter problems at once, because the Table defines the range explicitly instead of leaving Excel to guess it.

  1. Click any cell inside your data.
  2. Press Ctrl+T, or go to the Insert tab and click Table.
  3. Check the range shown in the dialog. It should cover your whole data block, including the header row.
  4. Tick “My table has headers” if your first row holds headers, which it should.
  5. Click OK. Filter arrows appear on the header row automatically.
  6. Click a dropdown arrow and check it lists values from the whole column.
  7. Add a new row at the bottom of the Table and confirm the filter range expands to include it automatically.

Tables have real advantages beyond fixing filters. New rows join the Table automatically, formulas copy down consistently, and the header row stays visible when you scroll if you turn on the Table’s header row option. The striped formatting can be changed or removed from the Table Design tab, so you are not stuck with a look you dislike. If you later want a plain range again, the Table Design tab offers “Convert to Range”, which keeps the data and the filter arrows but removes the Table structure.

Tables do have rules. A Table cannot contain merged cells, which is why Fix 3 comes first. A Table needs a header row with a unique name in each column, so two columns with the same header will cause Excel to rename one of them. If the conversion dialog shows the wrong range, fix blank rows and columns first, as in Fix 2, then convert. A Table built on a clean range is the most reliable filter setup Excel offers.

Fix 6: Clear Existing Filters and Check for Hidden Rows

A filter that is already applied changes what the dropdown shows. If a previous filter hides most rows, the dropdown lists only the visible values, which can look empty or broken. Clearing all filters restores the full list.

  1. Go to the Data tab and click Clear in the Sort and Filter group. This clears all filters on the sheet without turning the filter off.
  2. Check the row numbers on the left. Blue row numbers mean a filter is hiding rows. After clearing, they should return to normal.
  3. Select all rows by clicking the corner button above row 1 and left of column A, then right-click a row number and choose Unhide, to reveal any hidden rows.
  4. Do the same for columns: select all, right-click a column letter, and choose Unhide.
  5. Click a filter dropdown arrow and check whether it now lists the full set of values.
  6. If a dropdown still shows few values, click “(Select All)” in the dropdown list, then click OK, to make sure no value is excluded.
  7. Check for grouped rows and columns, shown by plus and minus buttons at the edge of the sheet, and expand any collapsed groups before filtering.

Hidden rows are easy to miss. A row hidden by a filter looks the same as a row hidden by hand, and both are invisible in the normal view. The Clear button only clears filters. It does not unhide rows hidden by hand, which is why the Unhide step matters. After clearing and unhiding, the dropdown should show every distinct value in the column.

Also check the filter dropdown’s search box. If text was typed into the search box during a previous filter, the list shows only matching values. Clear the search box and the full list returns. This small detail catches people out, because the search box keeps its text even after the dropdown closes and reopens. For data that refreshes from an external source, our guide to Excel PivotTable not refreshing covers stale data that looks like a filter problem but is actually a refresh problem.

Fix 7: Check Grouped Sheets, Shared Workbooks, and the Active Cell

When several sheets are grouped, Excel applies actions to all of them at once, and the filter button can grey out or behave oddly. A shared workbook restricts features, including filtering in some configurations. Both are quick to check.

A laptop showing an empty spreadsheet grid with coloured sheet tabs along the bottom
Grouped sheets apply every action to all of them at once. Ungroup before judging the filter.
  1. Look at the sheet tabs at the bottom. If several tabs are highlighted, or the title bar says Group, the sheets are grouped.
  2. Right-click any sheet tab and choose Ungroup Sheets.
  3. Click a cell inside your data on the single active sheet.
  4. Turn the filter off and on again, as in Fix 1, and test the dropdown.
  5. Check whether the workbook is shared: go to the Review tab and look for Share Workbook or the sharing status. In newer Excel, check File, then Info, for sharing and co-authoring status.
  6. If the file is open in co-authoring with other people editing, ask them to close it, or make your own copy and test the filter there.
  7. Make sure the active cell is inside the data range, not on a chart, a picture, or an empty area, before turning the filter on.

Grouping happens by accident more often than people realise. Clicking a sheet tab while holding Ctrl or Shift groups sheets, and the grouping stays until you ungroup. While grouped, typing, formatting, and filtering affect every grouped sheet, which is why Excel restricts some actions. Ungrouping is always the first step when the ribbon behaves unexpectedly and several tabs look selected.

Co-authoring adds another layer. When several people edit the same workbook online, one person’s filter can affect what another sees, depending on the Excel version and settings. If the filter works in your own copy but not in the shared file, co-authoring or shared-workbook restrictions are the cause. Work in your own copy for filtering, or agree with the other editors to clear filters before saving.

Fix 8: Check Frozen Panes, Zoom, and the Arrow Position

Sometimes the filter works, but you cannot see or click the arrow. Frozen panes, a very low zoom level, or a header row scrolled out of view can hide the arrows or place them where clicks miss. This fix is about visibility, not data.

  1. Scroll to the very top of the sheet and check whether the header row and its arrows are visible.
  2. Go to the View tab and check Freeze Panes. If panes are frozen below the header, the arrows stay visible while scrolling, which is correct. If panes are frozen in an odd place, unfreeze them and refreeze below the header row.
  3. Set the zoom level to 100 percent using the zoom slider at the bottom-right, and check the arrows again.
  4. Widen any very narrow columns. An arrow in a column only a few pixels wide is hard to see and hard to click.
  5. Click directly on the small arrow button at the right edge of the header cell, not in the middle of the cell. Clicking the middle only selects the cell.
  6. If you use a touch screen, use a mouse or the keyboard for this test, to rule out touch accuracy.
  7. Turn off any screen magnifier or display scaling change temporarily, and test the arrow click again.

A column too narrow for its arrow is a surprisingly common cause of “the dropdown will not open”. The arrow is there, but it is squeezed into a few pixels, and clicks land on the cell instead. Double-clicking the column border auto-fits the width to the contents, which usually restores a clickable arrow. The same applies to a header row with a very small row height: increase the row height so the arrow has room.

Frozen panes deserve a careful look. Freezing panes below row 1 keeps the header visible, which helps filtering. Freezing panes in the middle of the data, or freezing the top rows and the left columns in a way that hides the header, can make arrows appear in unexpected places. Unfreezing and refreezing cleanly below the header row removes that confusion.

Fix 9: Disable Add-ins and Test Excel in Safe Mode

Add-ins extend Excel, and they can interfere with the ribbon, with clicks, and with filtering. Safe Mode starts Excel without add-ins and without custom settings, so it is the cleanest test of whether an add-in is the cause.

  1. Close Excel completely.
  2. Hold the Ctrl key and click the Excel icon to start Excel. Keep holding Ctrl until Excel asks whether to start in Safe Mode, then click Yes.
  3. Open your workbook in Safe Mode.
  4. Click a cell inside the data and turn the filter on, as in Fix 1.
  5. Test the dropdown arrows. If they work in Safe Mode, an add-in is the cause.
  6. Close Safe Mode and open Excel normally. Go to File, then Options, then Add-ins.
  7. At the bottom of the Add-ins page, choose COM Add-ins in the Manage box and click Go. Untick add-ins one at a time, restarting Excel after each change, until the filter works. Leave the culprit off, or check the add-in maker’s site for an update.

Test add-ins one at a time. Disabling all of them at once and finding the filter works tells you an add-in is to blame, but not which one. Re-enabling one at a time finds the culprit. Pay attention to add-ins that manage data, add ribbon buttons, or connect Excel to other programs, because those are the ones most likely to touch filtering.

Safe Mode also disables custom toolbars and some startup settings, so a filter that works in Safe Mode but fails in normal mode with all add-ins off points to a custom setting or a startup file. In that case, check the Excel startup folder for files that load automatically, and move them out temporarily to test. Do not delete startup files. Move them to a backup folder so you can restore them.

Fix 10: Check Protected View and File Permissions

A file opened in Protected View cannot be edited, and filtering is blocked along with editing. A file with view-only permissions, or a file opened from a read-only location, behaves the same way. Both show no obvious error. The filter simply does not respond.

  1. Look at the top of the Excel window for a yellow bar saying Protected View, or a message that the file is read-only.
  2. If Protected View is on, and you trust the file and know where it came from, click Enable Editing.
  3. Test the filter dropdown after enabling editing.
  4. If the file is read-only, use File, then Save As, to save a copy in a folder you can write to, such as Documents.
  5. Open the copy and test the filter there.
  6. Check the file’s properties in File Explorer: right-click the file, choose Properties, and make sure the Read-only box is unticked.
  7. If the file comes from email or a download, and you trust it, unblock it in Properties if a security warning offers that option, then reopen it.

Protected View exists to keep you safe from files that may carry harmful macros. Only enable editing for files you trust and expected to receive. If a file arrived unexpectedly, even from a known sender, be cautious. Enabling editing on an untrusted file is a risk that no filter problem justifies.

A file stored in a synced folder, such as OneDrive or a shared drive, can also open read-only if another person has it locked, or if sync is paused. If the filter works on a local copy but not on the synced file, the sync or lock state is the cause. Wait for sync to finish, or work on the local copy and save it back when the lock clears. For workbooks that open to a blank screen, our guide to Excel workbook opens blank covers display and file problems that can travel with permission trouble.

Fix 11: Repair Office and Move Data to a New Workbook

The last steps separate a damaged file from a damaged installation. If the filter fails in one workbook only, the file is likely damaged. If it fails in every workbook, the installation is suspect. Test both, in order.

  1. Create a new blank workbook.
  2. Type a small table: three columns with headers, and five rows of simple values.
  3. Turn on the filter and test the dropdowns. If they work, Excel itself is fine, and the original file is the problem.
  4. If the new workbook also fails, repair Office: close all Office programs, open Windows Settings, then Apps, then Installed apps, find Microsoft 365 or Office, choose Modify, and run Quick Repair.
  5. Test the filter again after the repair. If it still fails, run Online Repair instead, which downloads fresh files.
  6. If only the original file fails, open it with Open and Repair: in Excel, click File, then Open, then Browse, select the file, click the arrow next to Open, and choose Open and Repair.
  7. If repair does not help, copy the data to a new workbook. Select the data, copy it, and paste values into a new workbook, then reapply formatting and turn on the filter. Work on a copy, and keep the original file untouched.

Open and Repair is Excel’s built-in file recovery tool. It rebuilds damaged parts of the file, including corrupt filter definitions, and it reports what it fixed. It works best when the damage is limited. A severely damaged file may open with some formatting or formulas lost, which is why working on a copy matters. Never let a repair overwrite your only copy of an important file.

Copying data to a new workbook is the most reliable escape from a damaged file. Pasting values avoids carrying corrupt formatting or definitions across. You lose formulas in the process, so if the workbook relies on formulas, paste formulas in a second pass, or rebuild the formulas in the new file. The effort is worth it for a file you will keep using. A filter that works in a clean file, built from the same data, proves the old file was the problem. For formula errors that can masquerade as data problems, our guide to Excel SPILL error fix covers errors that block results from displaying.

A laptop showing a spreadsheet with a small open dropdown menu of abstract list rows
A clean test table in a new workbook proves whether Excel itself works. If it does, the original file is the problem.
Hands working on a laptop showing two spreadsheet grids side by side with a printed grid sheet
Moving data to a fresh workbook leaves corrupt filter definitions behind. Work on a copy and keep the original untouched.

What to Avoid

  • Do not merge cells in the header row — merged headers hide or break filter arrows.
  • Do not leave blank rows or columns inside your data — they split the filter range in two.
  • Do not use password-cracking tools on a protected sheet — ask the owner for the password, or work on a copy of the visible data.
  • Do not install add-ins from unofficial sources to “fix” filtering — add-ins are a cause of filter trouble, not a cure.
  • Do not turn the filter on with the active cell outside the data — Excel guesses the range from the active cell.
  • Do not enable editing on an untrusted file just to test a filter — Protected View exists for a reason.
  • Do not let a repair overwrite your only copy of a file — work on a copy and keep the original safe.

Frequently Asked Questions

Why is the Excel filter dropdown not showing values?

The dropdown shows values from the filter range. If the range is wrong, a filter is already applied, or rows are hidden, the list looks empty or short. Clear all filters, unhide rows, and reapply the filter on the correct range, as in Fixes 1 and 6. excel filter dropdown not working with an empty list is usually a range problem, not a broken dropdown.

Why is the filter button greyed out in Excel?

A greyed-out filter button usually means the sheet is protected, several sheets are grouped, the file is in Protected View, or the workbook is shared with restrictions. Check protection on the Review tab, ungroup sheets, and check for a Protected View bar, as in Fixes 4, 7, and 10.

Why does the filter only cover part of my data?

A blank row or column inside the data splits the range, so the filter covers only the block containing the active cell. Remove blank rows and columns, or select the full range by hand before turning the filter on, as in Fix 2. Converting the range to an Excel Table, as in Fix 5, defines the range explicitly and prevents the problem returning.

Can merged cells break Excel filters?

Yes, especially in the header row. A merged header spans columns, so Excel cannot place arrows correctly. Unmerge the header row, as in Fix 3, and use Centre Across Selection instead of merging if you want a centred title. Keep merged cells out of the data range entirely.

Why does the filter work in one workbook but not another?

A filter that fails in one file only points to that file: its layout, its protection, or damage to the file itself. Check blank rows, merged cells, and protection in that file, then try Open and Repair or copy the data to a new workbook, as in Fix 11. A filter that fails everywhere points to Excel itself or an add-in, as in Fix 9.

Does converting to an Excel Table fix filter problems?

Often, yes. A Table defines the range, adds filter arrows automatically, expands when you add rows, and forbids merged cells inside it. Converting a clean range to a Table, as in Fix 5, fixes range-guessing problems permanently. Fix blank rows and merged cells first, so the Table is built on clean data.

Conclusion

When excel filter dropdown not working stops you working through a list, the data layout is the first suspect: the wrong row, a blank row splitting the range, or a merged header confusing the arrows. Protection, an existing filter, and grouped sheets explain the silent refusals, and add-ins and file damage explain the cases that affect every workbook or one file only. Work through the fixes in order, test on a copy if the file matters, and finish by converting clean data to an Excel Table so the filter keeps working. A dropdown that lists every value in the column is the proof that counts.

Helpful Official Resources

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *