View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEP DEP is offline
external usenet poster
 
Posts: 8
Default where to put results of find operation in find and replace fun

I went in using the edit pulldown, then find, which would be the = of
<Cltrl< F. However the option to select what to do with the results
appears to only be offered on the first use of the find / find and replace
function. I can't believe it can't be changed after the initial selection,
but it sure is hidden.

"kassie" wrote:

re yoiu sure you are talking about Find and Replace, as in <Ctrl<H? I use
it quite often, but have never ever seen such options. The only options I've
seen is format and such options. Iow, options to help you restrict your
search to specific instances, such as to search for SEARCH, but to ignore
Search and search

"DEP" wrote:

in EXCEL 2002 during the first use of find and replace one is asked what to
do with the results of a find. Either to copy to another location in the
worksheet, or list at the bottom of the find window. How does one get back
to that query screen to change the result action after the initial pass?