Excel spreadsheet applications and tips

Home

 

How to solve if Filter function does not work properly in MS Excel?

 

One of the most common problem with filter function is that it stops working beyond at a blank row. Filter will not include cells beyond the first blank.

To avoid this issue, select the range before applying the filter function. Please refer to the following excel spreadsheet for example.

 

1. Before applying filter on column C, either select the entire column C or the data that needs to be filtered.

 

2. Select Filter option under Data tab. Now all items appear in the filtered list as well as filter checkbox list.

 

External links for other issues that might prevent unhide function to work properly

Filters do not include cells beyond first blank

Excel won’t filter whole column

Excel how to filter properly

 

Search engine keywords for this question:

Filter function not working properly in Excel 2007, 2010

Excel not filtering the entire column

Excel not filtering all entries

Filter not showing all data in a column

Unable to filter properly in MS Excel