Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
You can make a difference in the Apple Support Community!
When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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?
