Issue with Find & Replace feature - can only find and replace with in formulas not values

Occasional Visitor

Hi there, 


I face a strange error in excel within the find and replace feature. I cannot select values to find and replace. Pre-selected is formulas and I cannot change it - cannot select any other option - see attachement. 


Anybody an idea?



1 Reply


In the Find tab of the Find and Replace dialog (1. in the screenshot), you can select Formulas, Values or Comments. But in the Replace tab (2. in the screenshot), you can only select Formulas.


For cells that contain fixed values, the effect is the same as if you could select Values.

But for cells that contain formulas, it would not make sense to be able to select Values: the value of such a cell is a result of the formula, you cannot replace it with something else.