Forum Discussion
Find cells hidden by filter
I never realized but FIND (and the equivalent function in VBA) only looks at the selected cells of a Filter. I can see no option to change that behaviour. Does anyone know how to search all cells (...
I run 365
I'm puzzeled too but for another reason...
Formatted as Table:
If I filter the table to show a only and do a Find All jones, no problem I get:
Formatted as Table:
If I filter the table to show a only and do Find All 500, no problem too
However, with the same setup and the table filtered to show a only, if I select the whole column A and do a Find All 500 (or Jones with 1st table) ==> NOT FOUND
Also, if instead of formatting as Table I activate the Home/Filter functionnality, filter the column to show a only and do a Find All (w/o selecting the column) ==> NOT FOUND too
The search results inside the Home/Find pop-up appear to be a feature of a structured Table. When I use such, I get your picture too. But it makes no difference to the result: Find All will not list any records hidden by the Filter setting.