copy formulae in excel

  • Thread starter Thread starter beginner
  • Start date Start date
B

beginner

How do I copy a formulae to next rows without having Excel update the
formulae in relation to the new cell?
 
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.
 
Back
Top