How to solve when filter function does not work properly in MS Excel?

One of the most common problem with filter function is that it stops working beyond 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.

Similarly you may select multiple columns or a range of cells before applying the filter.

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

Reasons why your Excel filter may not be working

Excel how to filter properly

Filters do not include cells beyond first blank

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

Leave a Reply

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