Hi all - when I use the FIND dialog box, the 'Look in' dropdown gives a choice of Formulas, Values, or Comments. However when I switch to 'REPLACE' those choices disappear and only 'Formulas' is left. Usually what we want to replace is Values however. I have searched settings, options, you name it to no avail. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
'Replace' function stuck on Formulas (ctrl-F) 1
- Thread starter EcoWill
- Start date
-
1
- #2
SkipVought
Programmer
First you must COPY your cells containing formulas and Edit > Paste Special -- VALUES.
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...for a NUANCE!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question