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
|