find and replace formulas keeping relative addresses

D

davegb

I have some spreadsheets with incorrect formulas. I'd like to replace
the existing formulas with correct ones. I can't do a fill down because
there are merged cells in the column. Is there a way to do a find and
replace to change the formulas?
I did do a search in this NG for this answer, and a found a thread
called "find and replace formulas but keep relative addressing". I
tried that solution, which was very brief, and got no results. Does
anyone know of a way to do this?
 
D

davegb

Sorry! I went back and played with more variations on the solution
offered by Bernie in an earlier thread, and I figured it out. I had to
select the column in which the erroneous formulas occured first, then
do the Edit, Goto, Special, Formulas, Ok. The first formula in the
first cell in the selected column is displayed. I corrected this
formula, then hit Ctl Enter, and all the formlas in that column were
changed to the correct one.
 
K

Ken Wright

Many thanks Dave - Lots of people would not have bothered to come back and
close the thread, let alone explain what they had done. Makes our lives a
lot easier. :)
 
Top