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

On Mon, 12 Jan 2009 05:24:03 -0800, Tazeem
wrote:

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