copy formulae in excel

[beginner]

How do I copy a formulae to next rows without having Excel update the
formulae in relation to the new cell?

 

[Gary''s Student]

If you use $ signs in the function references, they won'tupdate on Copy

 

[JLatham]

Easiest way is to make the cell references absolute. If your formula looks
like this:
=A5 + B6
change it to
=$A$5 + $B$6
and then you can copy it without changing the references. The $ makes the
reference absolute. Look at Excel's Help topic for Absolute and/or Relative
addressing.