Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Find Dialog at WorkbookOpen | Excel Discussion (Misc queries) | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
excel and VB Open Dialog box | Excel Discussion (Misc queries) | |||
navigate in Excel worksheet without scrolling | Excel Worksheet Functions | |||
How can I make the find dialog box appear as soon as I open a spr. | Excel Discussion (Misc queries) |