FIND OPTION

T

Tazeem

Hi to all,
Is it possible that any searched cell through "control+F' should be appeared
at the first row?
Thanks in advance,
Tazeem
 
G

Gord Dibben

Not without using VBA and then only if there is one found cell.

If you foind 9 instances of the the value, which one should be on the first
row?

How about you use Autofilter to find the value?

That will hide all rows without the value.


Gord Dibben MS Excel MVP
 
T

Tazeem

I am sorry ! I repeat my question "Is it possible that any searched cell
through (control+F or any other command) should be appeared at the top of
page or sheet?
Regards
 
Top