Repeating formulas when inserting new row


J

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?
 
Ad

Advertisements

L

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.
 
G

Glenn

junzworld said:
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top