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.

2 Answers 2

I think what you want may be an array formula. Say B1:B4 contains 1,2,3,4 respectively, and the formula in A1 is:

=ArrayFormula(B1:B^2)  

A1:A4 should show 1,4,9,16 respectively.

Select Row3 and Insert 1 above. The results in A1:A5 should now be 1,4,0,9,16 respectively.

Enter say 10 in B3 and the 0 in A3 should change to 100.

share|improve this answer

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

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.