title: How to keep one field fixed in a formular when using auto-fill?
body: <p>I want to autofill a formula to a bunch of fields in one column. I can do that by filling two fields manually then select them and drag down. </p>
  
  <p>I want column B's cells to be =D1*A1 , =D1*A2,... Note D1 should not change.</p>
  
  <p>When I drag the fields down or use (Edit > Fill...) it changes D1 to D2, D3,... How can I keep one field fixed for autofill?</p>
  
  <p>Holding ctrl button down does not help.</p>
  
  <p>Any idea?</p>