Can you change the defaults for Excel <Edit> <Find>?

N

Nino Richards

In excel when you do an <Edit> <Find> the default is find in a formula. If
you do not remember to change to value, it will never find text or numberics
that are actually there. Does anyone know if you can change the default to
find "values" or text?

Thanks for the help.
Nino
 
P

Peo Sjoblom

It will still find values, try it

put abc in A1, in A2 put ="abc"
in A3 put abc

do edit>find and use abc, then just click find next


Regards,

Peo Sjoblom
 
Top