im confused?

[Guest]

when i insert a new row the formula i have in every cell for a particular column does not automatically get put in the new cell in the new row. how can i get the formula to be in the new cell of the new row that i insert?

 

[J.E. McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm