Excel 2007 : Find and Replace - Only showing Look in: "formulas"

[jdfjab]

I must need more coffee. I'm attempting a find and replace but the excel forms box is only showing Look In: "Formulas" as an option. I need the find and replace to look in values.

Why is the "values" selection not showing?

[dilipandey]

Hi jdfjab,

Are you able to see the third option i.e., "Comments" ?
And by forms box do you mean the window which appears when we do Ctrl + F... Just wanted to be sure of. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[JosephP]

you cannot perform a replace operation on the result of a formula - you'd have to replace the formula. any cells with values instead of formulas in will still be included in the find and replace.