Repeating formulas when inserting new row

[junzworld]

How do I get excel 2003 to insert the formula if I insert a row? Right now I
am dragging the cell above it to the one below it. I would just like it to
automatically be in the cell that I am inserting. Is this possible?

 

[Luke M]

Not really. You might be able to write a VB script that would rewrite your
formulas upon insertion of row, but it would not be a simple fix. Another
problem is that when you normally insert a row, the formula in cell below
does not float, but stays pinned to whatever cell it was looking at before.

I believe Excel 2007 has this feature, though.

 

[Glenn]

How do I get excel 2003 to insert the formula if I insert a row? Right now I
am dragging the cell above it to the one below it. I would just like it to
automatically be in the cell that I am inserting. Is this possible?

Edit / Copy
Insert / Copied Cells

 

[Gary''s Student]

Very nice. I have never seen this before.