LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Navigate excel worksheet with find dialog box open

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Find Dialog at WorkbookOpen Rob Excel Discussion (Misc queries) 3 September 22nd 09 06:56 AM
Excel Open Dialog Improper Sort [email protected] Excel Discussion (Misc queries) 4 May 17th 06 02:40 PM
excel and VB Open Dialog box Anakin Moonwalker Excel Discussion (Misc queries) 2 September 13th 05 08:38 AM
navigate in Excel worksheet without scrolling johnson.82 Excel Worksheet Functions 2 April 7th 05 03:55 PM
How can I make the find dialog box appear as soon as I open a spr. christieb1975 Excel Discussion (Misc queries) 2 January 28th 05 06:47 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"