simple question on formulas and autofil

[R1CHO]

this seems a very basic question but ...
when auto-filling cell references automatically adjust accordingly, how do I
prevent a particular cell reference to changing? For example, I want my
result to look like this: cell1: =A1+A2+J4; cell2: =B1+B2+J4; cell3: =C1+C2+J4

 

[Gord Dibben]

=A1+A2+$J$4

The $ signs make the J4 Absolute for Column and Row

See more on Absolute and Relative cell referencing in Help.


Gord Dibben MS Excel MVP