Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

If I have a formula (of any kind) spanning A1:A30 (just as an example), when I right click and insert a new row, it doesn't have the same formula.

Numbers (and I believe Excel) allows this, is there a way to obtain this behavior in Google Spreadsheets?

share|improve this question

migrated from superuser.com May 26 '11 at 20:03

This question came from our site for computer enthusiasts and power users.

1 Answer 1

If instead of just inserting a row, you select a row, copy it and then Insert copied cells it should duplicate your formulas

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.