Forum Discussion
Filter working and then only partially working
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work - for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the 'OK's, but then some Queried, etc.
I couldn't figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again.
I am not sure what is happening.
I have attached a screenshot of the specific row in my spreadsheet - it is filtered on OK
When you activated the filter arrows, Excel looked at the 'current region' of row 1, i.e. A1:F53. The rows below are not included since row 54 is completely empty.
Do the following:
- On the Home tab of the ribbon, select A1, then in the Editing group, select Sort & Filter > Filter to turn the filter arrows off.
- Select the entire range A1:F146 (or further down if your real data extend further down).
- On the Home tab of the ribbon, select A1, then in the Editing group, select Sort & Filter > Filter to turn the filter arrows on again.
- Filter the data, for example on OK. You'll see that it works correctly now.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Hi there!
Ok I have attached a sample spreadsheet that I have adjusted - it does not include all of the columns in my spreadsheet, and also all the numbers have been changed just for privacy reasons, however the layout of the spreadsheet and the errors I am asking about remain.
Please note the following issues with the filter option:
1. The filter for the Invoice number column (column A) only shows one invoice number, however there are three listed?
2. The filter for the Approved column (column E) on shows 'OK' and 'Queried' as options to filter (there should also be 'To Query' and 'Resolved' on this list)
3. When I filter in the Approved column, for example 'OK', it shows other options also (such as To Query)
Thanks so much for your help!When you activated the filter arrows, Excel looked at the 'current region' of row 1, i.e. A1:F53. The rows below are not included since row 54 is completely empty.
Do the following:
- On the Home tab of the ribbon, select A1, then in the Editing group, select Sort & Filter > Filter to turn the filter arrows off.
- Select the entire range A1:F146 (or further down if your real data extend further down).
- On the Home tab of the ribbon, select A1, then in the Editing group, select Sort & Filter > Filter to turn the filter arrows on again.
- Filter the data, for example on OK. You'll see that it works correctly now.
