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?

link|improve this question
feedback

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

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

1 Answer

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown