FIND OPTION

[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

 

[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

 

[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

 

[David Biddulph]

I didn't understand your question, but Gord answered it yesterday:

 

[Gord Dibben]

Let's be generous to OP and call it a reply rather than an answer<g>


Gord