G
Guest
Hi,
When I'm in Excel03 and try to find a value (which I know is there) it
returns "MS Excel cannot find the data you're searching for."
I've found that in options you can change "Look in:" from formula to values.
My question is, can I make the "Look in:" option default to values instead
of formula, as 99% of my find and replace is for values and not formulas.
Thanks in advance.
AW
When I'm in Excel03 and try to find a value (which I know is there) it
returns "MS Excel cannot find the data you're searching for."
I've found that in options you can change "Look in:" from formula to values.
My question is, can I make the "Look in:" option default to values instead
of formula, as 99% of my find and replace is for values and not formulas.
Thanks in advance.
AW