Drag a Named Formula

A

aynsley

I have a named formula that references cells in the same row. Is there a way
to drag the named formula down so that it references the cells in the new row
rather than keeping the references from the row it was named in?
 
F

FSt1

hi,
not sure what you mean by "drag" but if the formula does not have absolute
references in it, you can copy the formula and paste it one row down or down
the entire column. the formula will reference the cells in the row that it
was pasted in.
if the formula has absolute references in it, change them to relative
references.
relative reference = A1
absolute reference = $A$1

regards
FSt1
 
Top