The Excel Filter is Not Working After a Row – 4 Reasons and Solutions

 

This is the sample dataset.

Dataset for Filter Is Not Working After Certain Row in Excel

A filter was applied for Texas, but it is not working after row 6.


Reason 1 – Blank Cells in the Range

  • To check it, click the filter.

Excel Filter is Not Working After Certain Row Because of Having Blank Cell in Range

  • You will see where the filter is added.

Clicking on Filter Button to See Where the Problem is when Excel Filter Is Not Working After Certain Row

  • Check Select All.
  • Click OK.

Select All to See All the Data When Excel Filter is Not Working After Certain Row

  • You will see all data. The filter was not working after the blank cell.

Solution: Select Whole Range Before Applying Filter

  • Select the cell to add the Filter.
  • Go to the Data tab.
  • Click the Filter to remove it.

Select Whole Range Before Applying Filter

  • Select the entire range with the blank cells.
  • Go to the Data tab.
  • Select the Filter.

Selecting Whole range Then Adding Filter when It is Not Working in Excel

  • Click the button, as shown below, to apply the Filter.

Selecting Filter Button When Excel Filter Is Not Working After Certain Row

  • Select the fields you want to filter. Here, Texas.
  • Click OK.

  • This is the output.


Reason 2 – The Range Contains Hidden Cells

  • Click the Filter.

Range Contains Hidden Cells

  • You will see where the filter is added.

Excel Filter Is Not Working Because Range Contains Hidden Cells

  • Check Select All.
  • Click OK.

  • You will see that the dataset does not contain blank cells, but Row 8 is missing.

Solution: Unhide Hidden Cells and Select the Whole Range

  • Place the cursor where the row is missing.

Unhide Hidden Cell & Select Whole Range

  • Right-click.
  • Select Unhide.

  • You will see all cells and blank cells.

  • Select the cell where the Filter is.
  • Go to the Data tab.
  • Select Filter.

  • Select the whole range to apply the filter.
  • Go to the Data tab.
  • Select Filter.

  • Click the Filter.

  • Select the field to apply the filter.
  • Click OK.

  • The Filter is working.


Reason 3 – There are Merged Cells in Filtered Range

. In the following image, the filter is applied to Florida and Texas, but the table also contains Ohio.

Having Merged Cells in Filtered Range

  • To see all data, click the filter.
  • Check Select All.
  • Click OK.

  • You will be able to see all data. There is a merged cell.

Solution: Unmerge Cells

  • Select the merged cell.
  • Go to the Home tab.
  • Select Merge and Center.

Unmerge Cells When Excel Filter is Not Working After Certain Row

  • Cells are unmerged.

  • Enter data in the blank cells.

  • Click the Filter.
  • Uncheck the options you don’t want to Filter.
  • Click OK.

  • The Filter is working.


Reason 4 – Adding Data After Applying the Filter in Excel

In the following dataset, you can see the filter is applied to “Texas”. But it is not working after Row 13. Data was added after applying the filter.

Excel Filter Is Not Working After Certain Row Because of Adding Data After Applying Filter

Solution: Reapply the Filter

  • Select the cell to aplly the Filter.
  • Go to the Data Tab.
  • Select Reapply.

Reapply Filter

  • The Filter is working.

Reapplying Filter When Excel Filter is Not Working After Certain Row


Download Practice Workbook

Download the practice workbook.


<< Go Back to Not Working | Filter in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo