Go to goto - FIND

  • Thread starter Thread starter Teddy-B
  • Start date Start date
T

Teddy-B

I just want to go to a certain row that contains data meeting certain
criteria. (Example: =h3). How do I do this?
 
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!
 
Back
Top