Keep find box open while in spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!!!
 
Frantic Excel-er said:
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!!!!!
Click to expand...

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

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

Excel Spreadsheets keep moving 0
FIND command 4
Excel Excel spreadsheets opening at top instead of bottom. 4
Spreadsheet constantly reverts to manual calculation mode 3
Navigate excel worksheet with find dialog box open 7
open spreadsheets into separate excel instance 1
Keep spreadsheet on pc & laptop in sinc -how? 3
Find/Replace - Full Navigation of Spreadsheet 2

Back
Top