Navigate excel worksheet with find dialog box open

[Mr TJA]

I am using Excel 2000 on Windows XP.
How can you set an option so you can navigate the worksheet while you have
the find dialog box open. It appears very fundamental that one would want to
look for an occurence of a value or string, then make an edit, then "find
next" the next occurence, repeat the edit, etc ...
This is not an example of a search and replace. I am looking up certain
values, which takes me to a certain area of a 12,000 line long worksheet.
Then I page iup or down withing this area up to 100 rows. to find another
value.
This is not an example of Vlookup either, as no patterns exist.

I need to be able to use find next and have access to the worksheet without
having to close the find box in between each edit.

 

[Gord Dibben]

Have never used Excel 2000 but in 2003 version you can Edit>Find>Find Next to
go to first found cell.

Hit F2 and do your cell editing then ENTER without closing the Dialog box.

Find Next goes to next cell.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

In xl2k, you have to dismiss that Edit|find dialog before you do anything to the
worksheet.

I don't recall if this changed in xl2002 or xl2003, though.

 

[Dave Peterson]

Maybe you can use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

 

[Gord Dibben]

Definitley has been changed for 2003.

Re-read my post that you responded to, eh?


Gord

 

[Dave Peterson]

I still primarily use xl2003. I'm too lazy to start up a virtual pc to get to
xl2007. And I didn't keep xl2002 installed, so I can't check that.

 

[Gord Dibben]

Been a couple of years but I don't think 2002 was same as 2003.

You still had to dismiss the dialog before editing.


Gord

 

[Dave Peterson]

Maybe someone using xl2002 will jump in with a confirmation???