Keep find box open while in spreadsheet

[Guest]

Hi...
I was wondering how I can keep my find box open while I am entering and
editing data in my spreadsheet. It is very frustrating to have to
continually select the find option, type in what I want to find, close the
window, do any changes or calcs, and then reopen to find the next. I am using
Excel 2000.

HELP!!!!!

 

[Doug Kanter]

Hi...
I was wondering how I can keep my find box open while I am entering and
editing data in my spreadsheet. It is very frustrating to have to
continually select the find option, type in what I want to find, close the
window, do any changes or calcs, and then reopen to find the next. I am
using
Excel 2000.

HELP!!!!!

It's programmed that way. You can't change it. However, the CTRL-F keyboard
shortcut might try your patience less than the Edit, Find menu method.

 

[Guest]

I don't think you can keep it open-shortcut is Ctrl+F
Pat

 

[Guest]

I know I have been able to do it while working at a different company.
Anyone know if this changes for more recent versions of 2000?

 

[Harald Staff]

Hi

If you know a litttle VBA, build your own modeless Find - Replace dialog,
and add "find all", "search by format" and other cool features to it too.
Not only very useful, it's also great fun to do.

Best wishes Harald

 

[Harald Staff]

Yes. Excel XP and Excel 2003 can do that.

HTH. Best wishes Harald

 

[Guest]

Thanks Harald....don't know Visual Basic myself, but I might know someone who
does.