Excel spreadsheet applications and tips
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.
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
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