Go to goto - FIND
 

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

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?