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

Word macro that can call cells out of Excel for a find and replace 0
ASK Field Formatting 1
WORD VBA Search and switch to advanced ... 1
After Word 2013 crashed, the side panel with the Find Option and Chapter headings is missing 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Replace 1
how can i change a sequence of numbers using find replace 2
Find and Replace Command 1

Top