Forum Discussion
Solved
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, Q...
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.
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!
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.
- Oh wow, you're absolutely amazing! That worked!!! Thank you so much for that !!
