I have a sheet with a lot of columns with data and formulas. I need to insert a new row with the same formulas as the last row by clicking on a button. How can I do this?

  • Can you explain why you need a button instead of copying and pasting the row? A button will likely require a Google Apps Script which will make it much more complicated. May 18 at 13:07
  • Also, please edit your question to clarify what the last row means. For example, last row containing data? Last row in spreadsheet? Should the button be adding a new row to the sheet? May 18 at 13:15
  • see possible duplicate webapps.stackexchange.com/questions/47171/… May 21 at 15:47


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.