Jan 14 2021 06:27 AM
How can I copy a formula by pulling the cell I want to copy down the whole column? I used to be able to do this and now it doesn't work. Example of what I want it to do:
=SUM(F2*G1)
=SUM(F3*G1)
=SUM(F4*G1)
This is what it's doing that I don't want:
=SUM(F2*G1)
=SUM(F3*G2)
=SUM(F4*G3)
Thanks!
Jan 14 2021 06:45 AM
@soozstray No need for the SUM, but fix the G1 reference using $ signs like:
=F2*$G$1
and copy it down.