simple question on formulas and autofil
 

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

simple question on formulas and autofil
 

=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

On Mon, 31 Mar 2008 17:06:51 -0700, R1CHO
wrote:

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