title: copy and paste formula with constant cell
body: <p>I need to make Total_Price calculation of working hours:</p>
  
  <p>Excel sheet looks this way:</p>
  
  <pre><code>Job_name(A1);Time_spend(B1);Total_Price(C1);
  </code></pre>
  
  <p>And I have hour price in special constant cell - <code>F1</code>.</p>
  
  <p>To get Total_Price I'm using formula =B1*F1. After this I copy cell and paste into all rest cells in C column manually. According this procedure C2 gets formula =B2*F2, but I need =B2*F1. </p>
  
  <p>How to make this procedure more automatic?</p>