A formula copied by dRow rows and dCol columns (fill handle, copy and paste): relative references move, $ parts stay; a reference that leaves the sheet becomes #REF!. Formula text without =.
dRow
dCol
$
#REF!
=
the formula (without =)
rows moved
columns moved
the moved formula (canonical text)
shiftFormula("B2*C2+$F$1", 1, 0); // "B3*C3+$F$1"shiftFormula("A1", -1, 0); // "#REF!" Copy
shiftFormula("B2*C2+$F$1", 1, 0); // "B3*C3+$F$1"shiftFormula("A1", -1, 0); // "#REF!"
1.1.99
A formula copied by
dRowrows anddColcolumns (fill handle, copy and paste): relative references move,$parts stay; a reference that leaves the sheet becomes#REF!. Formula text without=.