Inserting a row

[Griet from Noosa]

Using Excel XP I need to insert a row in an exsiting table but it does not
copy the formula from the row above or/and below in to the new row. I also
use Excel 2000 and I have no problem. What am I doing wrong?????

 

[David McRitchie]

Whether you can use extend existing formulas (option) or not
you must write your formulas differently. See
Insert Rows and Maintain Formulas
http://www.mvps.org/dmcritchie/excel/excel.htm