Forum Discussion
Pinky1635
Dec 05, 2023Copper Contributor
Dragging and copying a formula
Hi, hoping someone can figure this out. I am trying to copy down a % increase - its a long list but it will not copy down. I have gone into automation and that is ticked, also file options advanced...
dhaval109D
May 27, 2026Copper Contributor
I like how this highlights that Excel isn’t just copying formulas blindly—it’s interpreting intent through relative positioning. The distinction between copying, dragging, and locking references with F4 is something that’s easy to overlook but makes a big difference in real usage.
https://superchess.iamraj.dev