How to fix ‘filter stops working part way down the spreadsheet’ in Microsoft Excel 2010?

Filtering data by selecting a value seems like a nice feature. You usually select a region; click a button, and Excel only selected records. Microsoft Excel 2010 does support selection filtering and it is just two clicks away.

Filtering data does makes your job easy, but what if the Excel filter stops working part way down the spreadsheet. It will certainly affect your work productivity.

For instance, you want to limit sports apparel sales records and you might go on doing it accordingly. And all of a sudden, your filter works for only the top part of the data in your spreadsheet, but stops working part way down. This issue might arise due to the addition of excess data in the spreadsheet. However, the steps given below will certainly help you in resolving this issue.

Here’s how the steps go:

1. If your Excel Autofilter stops working part way down the spreadsheet then use the ‘Sort & Filter’ drop down in the ‘Editing’ section to remove the Autofilter and then activate it again.
2. This causes the new data to be added to the range of filtered cells.

This is how you can fix up the issue when the filtering stops working part way down the spreadsheet in Microsoft Excel 2010. For further help, you can check out our video solution that is given below.

http://www.youtube.com/watch?v=LX0CtbYC-p4