#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default FIND OPTION

Hi to all,
Is it possible that any searched cell through "control+F' should be appeared
at the first row?
Thanks in advance,
Tazeem
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default FIND OPTION

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default FIND OPTION

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

"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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default FIND OPTION

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

--
David Biddulph

"Tazeem" wrote in message
...
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

"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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default FIND OPTION

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


Gord

On Tue, 13 Jan 2009 16:53:01 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The equivalent of a Find & Replace option Pat Charts and Charting in Excel 4 September 17th 08 04:22 AM
Find Option replacement erick-flores Excel Discussion (Misc queries) 1 February 8th 08 09:11 PM
when useing the find option in excel makten86 Excel Discussion (Misc queries) 1 February 8th 06 02:30 AM
Find and Replace - Quickest Option? Lindsey M Excel Worksheet Functions 1 March 8th 05 11:34 AM
need short cuts in the find option Trisher75 Excel Discussion (Misc queries) 5 March 3rd 05 10:07 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"