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?

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"junzworld" wrote:

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?

junzworld wrote:
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

Very nice. I have never seen this before.
--
Gary''s Student - gsnu200819


"Glenn" wrote:

junzworld wrote:
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