can Find/Replace "Look in:" be set to a different default option?

[lagrangePoint3]

initiate a Find and Replace
open options
The "Look in" drop down field defaults to formulas.
I wish to change the default to "values."

Thanks,

 

[RoryA]

A replace operation will only work with formulas as the option.

 

[lagrangePoint3]

ok, but I wasn't replacing anything. I was trying to find something, and every time I do, which is quite frequent, I have to change that parameter. Does anyone ever try to 'find' a formula? I don't even know how you'd do that. But no matter, is there a way to default the find tab, if you must, to look in values instead of formulas?

 

[RoryA]

It should persist between find operations in the same excel session, but there is no way to change the default. Note that the formulas option also works with literal values, not just actual formulas.

 

[lagrangePoint3]

ok, so once I set it in the current session it will stay that way for the remainder of the session.
And it works for values as well as formulas.
Thanks.