HELP How to keep the find and replace box open?

  • Thread starter Thread starter aivelira
  • Start date Start date
A

aivelira

Hello all!

Can anyone please, please, please help me?
I am working on a data entry project and althought the sheets I am
entering into the worksheet are alphabetically arranged, some of the
plant names have changed. I can't seem to find out how to keep that
find and replace window/box open so that I can be plugging along at
Abutilon and then jump to Zinnia and then back to Aster, without having
to close the box and check it off then reopen it to search again. You
see? Is there anyway to keep it open, where are the settings? I have
office 2000 Prof version.

Thank you!
Melissa :)
 
Upgrade to xl2002?

You can do other things to the worksheet when the find dialog is visible in
xl2002 and up.

Maybe you could create a little userform that mimicked the Find dialog--but
that's way too much work.

You may want to try Jan Karel Pieterse's FlexFind:
http://www.bmsltd.co.uk/MVP
or
http://www.bmsltd.ie/MVP/

You can search the whole workbook. And just click on one of the listed
addresses and off you go to that cell!
 

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

Similar Threads

Wifi mystery 12
Toggle between Find and Replace 4
Keep find box open while in spreadsheet 6
How to keep borders box open 1
Help! - Lost function in Find & Replace! 1
Replacing cell numbers but leaving leading zero 1
Find and Replace 2
Find / Replace 3

Back
Top