Find and Replace - Options

  • Thread starter Thread starter ripley
  • Start date Start date
R

ripley

Is there a way, in Excel 2003, to change the default Find and Replace options
to look for Values rather than Formulas in the Look In field? The data we
are searching is 90% values and we have to reset the Option time Excel is
restarted. We have some inexperienced users who forget to change the Options
and we do not catch all data.

Thanks
 
Record a macro to be the way you want>put in the personal.xls or failing
that in the auto_open of the first workbook.
 

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

Find & Replace Options 4
Find and Replace error 3
Find and Replace Command 2
Find and Replace looking for values 1
Find and Replace 4
Find / Replace 3
Change Excel Find & Replace Options Defaults 1
Set the Find and Replace, Options, 'Within' default to Workbook 1

Back
Top