View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Go to goto - FIND

1. In EXCEL 2007 I have entered:-

=h3

- into cell C23.

2. Click out of cell C23 say into cell L19 (this can be any cell).

3. Ctrl F (simultaneously).

4. Find and Replace should launch.

5. Enter:-

=h3

- into the Find what: field.

6. Hit Find Next.

7. EXCEL will take you to cell C23.

- and so on.

Please hit Yes is my comments have helped.

Thanks!



"Teddy-B" wrote:

I just want to go to a certain row that contains data meeting certain
criteria. (Example: =h3). How do I do this?