I’m trying to create a cell that contains a formula which can be auto filled down. I need certain values within the formula to change as they normally would when autofilling, but others I want to stay exactly the same. Is there any way to do this?
iPad Pro, iOS 13
Hi Sean,
The absolute reference operator ( $ ) is your friend here.
$A$1 + $B1 + C$2
If this formula were entered as shown in cell D11, then filled down to D20, the formula in
D20 would be: $A$1 + $B10 + C$2
If the formula in D11 were filled right to N11, the formula in
N11 would be: $A$1 + $B1 + M$2
and if filled down and right (or filled right and down) to
N20, would be: $A$1 + $B10 + M$2
Regards,
Barry
Hi Sean,
The absolute reference operator ( $ ) is your friend here.
$A$1 + $B1 + C$2
If this formula were entered as shown in cell D11, then filled down to D20, the formula in
D20 would be: $A$1 + $B10 + C$2
If the formula in D11 were filled right to N11, the formula in
N11 would be: $A$1 + $B1 + M$2
and if filled down and right (or filled right and down) to
N20, would be: $A$1 + $B10 + M$2
Regards,
Barry
Oh that’s perfect, thanks!!
AutoFilling: Keeping Certain Values the Same?
