title: How to Copy Paste Formula in Excel But Skip 1 Cell
body: <p>I am working on my report using WPS Office Excel (it is almost same like Microsoft Excel), I have 2 sheet For example, My report sheet is called "Report" and my data sheet is called "Data".</p>
  
  <p>In my "Report" sheet I need to copy paste formula like this</p>
  
  <p>from Cell AP12 </p>
  
  <pre><code>=((+Data!BK12*$P$11)+(Data!BL12*$Q$11))/$R$11
  </code></pre>
  
  <p>To Cell AQ12, I need the Cell AQ12 to become like this</p>
  
  <pre><code>=((+Data!BM12*$P$11)+(Data!BN12*$Q$11))/$R$11
  </code></pre>
  
  <p>But when I copy paste here's what happen in cell AQ12</p>
  
  <pre><code>=((+Data!BL12*$P$11)+(Data!BM12*$Q$11))/$R$11
  </code></pre>
  
  <p>Can </p>