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