Novice here.
Here's what I'm doing:
Copy - D6: =(c6*a4)
Copy down result - D7: =(C7*A5); D8: =(C8*A6)...
Desired copy down result - D7: =(C7*A4); D8: =(C8*A4)

I want to copy down but have A4 not increment.
How do I do this?
Thanks.