Excel Filter Not Working? Step-by-Step Fix

Your Excel filter is not showing all data, refusing to filter correctly, hiding rows unexpectedly, or missing filter dropdowns entirely.
This usually happens because of blank rows, merged cells, inconsistent formatting, or broken dataset structure—not because the filter feature itself is broken.

Why the Issue Happens

• Blank rows or columns breaking the dataset
• Merged cells interfering with filtering
• Filter applied to only part of the data
• Hidden rows already present before filtering
• Mixed data types in the same column
• Numbers or dates stored as text
• Corrupted or inconsistent headers
• Existing filters conflicting with new filters

Step-by-Step Fixes

Step 1: Select the Entire Dataset

Filtering works best when the entire table is selected.

Shortcut:

Ctrl + A

Then apply filter:

Ctrl + Shift + L

If only one column is selected, filters may behave incorrectly.

Step 2: Remove Blank Rows and Columns

Blank rows interrupt Excel’s understanding of the dataset.

Fix:

• Delete completely blank rows
• Delete empty columns inside the table

Your data should be continuous without gaps.

Step 3: Unmerge Cells

Merged cells often break filtering completely.

Fix:

Home → Merge & Center → Unmerge Cells

Then fill missing values properly.

Avoid merged cells in analytical datasets.

Step 4: Clear Existing Filters

Old filters may conflict with new filtering logic.

Go to:

Data → Sort & Filter → Clear

Then reapply filters.

Step 5: Check Header Row

Filters require proper column headers.

Bad example:

(blank header)

Fix:

Sales Amount

Rules:

• One header row only
• No merged headers
• No blank column names

Step 6: Fix Numbers Stored as Text

Text-formatted numbers filter incorrectly.

Check:

=ISNUMBER(A2)

If FALSE → convert values.

Fix:

=VALUE(A2)

Or:

Data → Text to Columns → Finish

Step 7: Fix Dates Stored as Text

Date filters fail if dates are text.

Check:

=ISNUMBER(A2)

Real Excel dates return TRUE.

Fix:

=DATEVALUE(A2)

Then format as Date.

Step 8: Remove Hidden Rows

Rows hidden manually before filtering can create confusion.

Fix:

1. Select all rows
2. Right-click → Unhide

Then apply filters again.

Step 9: Convert Dataset into an Excel Table

Excel Tables handle filters far better than raw ranges.

Convert using:

Ctrl + T

Benefits:

• Automatic filters
• Dynamic ranges
• Better sorting and filtering stability

Step 10: Check for Corrupted Formatting

Sometimes formatting corruption breaks filters.

Fix:

1. Copy raw data
2. Paste into a new worksheet using:

Paste Values

3. Reapply filters

This removes hidden formatting issues.

Common Mistakes

• Applying filters to only one column
• Leaving blank rows inside datasets
• Using merged cells
• Mixing text and numeric formats
• Using multiple header rows
• Forgetting hidden rows already exist

Pro Tips

Always structure data as Excel Tables

Keep one clean header row only

Avoid merged cells entirely in datasets

Standardize formats before filtering

Use helper columns to clean imported data first

Bottom Line

Fix filter issues in this order:

1. Select the full dataset
2. Remove blanks and merged cells
3. Verify headers and formatting
4. Convert text to proper numbers/dates
5. Use Excel Tables for stable filtering

Most Excel filter problems are caused by poor data structure and inconsistent formatting—not the filter feature itself.

Other Excel Fixes:

1. Excel Circular Reference Warning? How To Fix
2. Excel Formula Not Calculating? Fix It Fast
3. Excel INDEX MATCH Not Working? Complete Fix Guide
4. Excel XLOOKUP Not Working? Fix Errors Step-by-Step

More guides added daily.