The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
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
Oh that’s perfect, thanks!!
AutoFilling: Keeping Certain Values the Same?
