title: Excel : Drag cell with one cell gap
body: <p>I have the formula written in the cell B1 and need to drag it down till the <code>B100</code>.</p>
  
  <p><strong>Example</strong>:</p>
  
  <p>Formula for cell B1</p>
  
  <pre><code>=(A2 - A1)
  </code></pre>
  
  <p><strong>Note</strong>: Now I need to drag cell <code>B1</code> to <code>B100</code> and need one cell blank in between like shown below:</p>
  
  <p>Expected Result:</p>
  
  <pre><code>A       B
  -----------
  2       3
  5
  8       1    
  9
  </code></pre>
  
  <p>Is that possible to format the drag option?</p>