Edit > Replace

Z

Zee

Not sure how this happened, but could use some help.

I am trying do an EDIT > REPLACE in my excel workbook, but in the LOOK IN:
drop down box it only has "Formula" - The "Values" & "Comments" options are
NOT available to pick from. Subsequently, I am not able to do a "replace" in
any of my workbooks.

Any idea what happened to cause this and how to fix it?

While I'm here, I have another question to ask..
Is is possible to change the FIND & REPLACE "Look In:" default to "values"
instead of "formula" in the FIND and REPLACE feature.
 
D

Dave Peterson

Comments are not available via edit|replace.

But if you specify Formulas, your edit|Replace will look through formulas and
constants.

It doesn't make real good sense to do an edit|replace against the value that
comes from a formula:

If you had Z, E, E in A1:C1
and in D1, you had
=A1&B1&C1
so D1 evaluated to ZEE

It wouldn't make a lot of sense to be able to replace ZEE with QQQ. What would
you want it to do.
 
Top