A Adrian Sep 15, 2004 #1 Hi, How come i cannot do a Find and Replace for "values" in excel but only for formulae ?
J Jerry W. Lewis Sep 15, 2004 #2 What version of Excel? In Xp, there is an "Options >>" button in the Find and Replace dialog that gets you to the "Look in:" option. Jerry
What version of Excel? In Xp, there is an "Options >>" button in the Find and Replace dialog that gets you to the "Look in:" option. Jerry
D Dave Peterson Sep 15, 2004 #3 But if you do Edit|Replace, it'll replace it in the values (as well as the formulas). If you want to only touch values--not formulas, you can select your range then Edit|goto|special click on Constants then do your edit|replace. (Be aware that if your selection just changes to one cell, then excel will figure you want the whole sheet.)
But if you do Edit|Replace, it'll replace it in the values (as well as the formulas). If you want to only touch values--not formulas, you can select your range then Edit|goto|special click on Constants then do your edit|replace. (Be aware that if your selection just changes to one cell, then excel will figure you want the whole sheet.)
A Adrian Sep 16, 2004 #4 I am using Excel XP .. Replace >>Options >> Look in : And I only see the Formula option ONLY However. Find >> Options >> Look in: Have Formula , Value , Comments options...
I am using Excel XP .. Replace >>Options >> Look in : And I only see the Formula option ONLY However. Find >> Options >> Look in: Have Formula , Value , Comments options...
