title: Copying formula to the next row when inserting a new row
body: <p>I have a row in which there are formulas using values of the same row.
  The next row is empty, just with a different background color.</p>
  
  <p>Now, if I insert a new row (by right-clicking on the empty row and "insert"), I get a new row with NO background color (which is what I want), but the line also does NOT contain any formulas: how do I get Excel to be smarter and copying the formulas from the previous row, when creating the new row?</p>
  
  <p>One more piece of information: data validation information (i.e. a drop down list) is copied when inserting the new row.</p>
  
  <p>Thanks.</p>