simple question on formulas and autofil

R

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
 
G

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
 
Top