How to copy a formula in excel without the cell number getting updated

Question

I am trying to achieve the following scenario.

1. value of G1 has formula set to (=F1)
2. When I copy the formula to other cells in column G, I want the formula to saty same (=F1) instead of dynamically getting updated to next cell number in the F column like (=F2) etc.

Answer 1

For something like this you can use the $-symbol.

=$F$1

The $-symbol will take the following character as constant. So with the code above it will always refer to F1, no matter where you copy it.

Answer 2

This isn't really for Stack Overflow but the answer is to use absolute references and so your formula would be =$F$2 and wherever you copy it, it would still refer to that cell.

Another way to do this would be with named cells, but absolute references is probably simpler.