title: On row insertion autopopulate a formula in a cell
body: <p>I have a formula column in my spreadsheet to calculate values based on another column. I want to know if there is a way to make the formula default so that when I insert a new row, the cell of that column automatically gets the formula pre-set, no need to copy and paste from above again.</p>
  
  <p>This is desirable because the spreadsheet will be filled in by non-technical users. The current workaround is to pre-copy-&amp;-paste the whole column with the formula but this is not ideal as the file becomes unnecessarily large and slow to open.</p>
  
  <p>Any method even with VBA is acceptable but a non-VBA solution is preferable.</p>