Find and Replace - Options

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
 
D

Don Guillett

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 looking for values 1
Find and Replace 4
Find and Replace error 3
Find and Replace Command 2
Change Excel Find & Replace Options Defaults 1
Use Find and Replace in Excel 2
Set the Find and Replace, Options, 'Within' default to Workbook 1

Top