If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keep find box open while in spreadsheet
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!!!!! |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
I don't think you can keep it open-shortcut is Ctrl+F
Pat "Frantic Excel-er" wrote: 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!!!!! |
#4
|
|||
|
|||
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? "Frantic Excel-er" wrote: 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!!!!! |
#5
|
|||
|
|||
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 "Frantic Excel-er" Frantic skrev i melding ... 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!!!!! |
#6
|
|||
|
|||
Yes. Excel XP and Excel 2003 can do that.
HTH. Best wishes Harald "Frantic Excel-er" Frantic skrev i melding ... 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? "Frantic Excel-er" wrote: 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!!!!! |
#7
|
|||
|
|||
Thanks Harald....don't know Visual Basic myself, but I might know someone who
does. "Harald Staff" wrote: 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 "Frantic Excel-er" Frantic skrev i melding ... 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!!!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to find out VBA command that runs "Open" file dialogue box | Brent E | General Discussion | 1 | February 2nd, 2005 11:30 PM |
Excel won't open spreadsheet | optyk | General Discussion | 1 | October 15th, 2004 05:00 PM |
"Jet database engine could not find the object" when trying to open a *.mdb file. | Tony Toews | General Discussion | 0 | June 4th, 2004 12:55 AM |