copy formulae in excel
 

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

copy formulae in excel
 

If you use $ signs in the function references, they won'tupdate on Copy
--
Gary''s Student - gsnu201002


"beginner" wrote:

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

copy formulae in excel
 

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.


"beginner" wrote:

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