Go to goto - FIND

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?
 
T

trip_to_tokyo

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top