title: Arrayformula (google sheets) in Excel 2007
body: <p>Is there a way to use Arrayformula function as used in google sheets in Excel?</p>
  
  <p>For example: </p>
  
  <pre><code> A     B
  </code></pre>
  
  <p>1|  23<br>
  2|  45<br>
  3|  56</p>
  
  <p>If I'll write in b1 =Arrayformula(A1:A3*2)</p>
  
  <p>I'll get</p>
  
  <pre><code> A     B
  </code></pre>
  
  <p>1|  23 | 46<br>
  2|  45 | 90<br>
  3|  56 | 112</p>
  
  <p>How can I get same result on Excel 2007 using 1 formula (without dragging/ copying/ double clicking)</p>
  
  <p>Thanks ahead!</p>