Find and Replace - Options
 

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

Find and Replace - Options
 

Record a macro to be the way you wantput in the personal.xls or failing
that in the auto_open of the first workbook.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ripley" wrote in message
...
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