Forum Discussion
Find cells hidden by filter
You assumed right... On the other hand I wrongly assumed re. the FIND function
Given that the row where JONES exists - with my example - is hidden it seems logical to me that Excel tells you it doesn't find it. However, if you do Find All you get the info:
I am puzzled. How do you even get your dialogue box to look like this? Which Excel is that? Mine looks like this:
The 500 exist in the line filtered away but clicking Find All does not make the slightest difference. (My Excel is trying to show hits by putting the cursor there, not by listing them in the pop-up.)
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.