View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
R1CHO R1CHO is offline
external usenet poster
 
Posts: 1
Default 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