find and replace function is not working correctly

[rhino87]

I am having an issue with the find and replace function. I am only able to search formulas, and nothing else. Does anyone have any suggestions?

[icestationzbra]

in the Find and Replace window, click on the Options button and select Values from "Look in" field dropdown.

[Isara]

I'm actually having the same problem in Excel 2010 Professional. Quite out of the blue, the pulldown menu (Options->Look in:) is only showing Formulas as an option. For me, it's only in the Replace tab. Find is fine. I even tried stripping out the Formulas to just get the values, and I quit and restarted, but it's still missing the Values option.

find-replace.gif