update formula chain when inserting rows

**rjmills18** · 08-27-2008, 07:57 AM

hi
is there a way which my formula chains can be updated when inserting rows? i.e. the calculating formulas that run down my columns, are broken when a new row is inserted, that is, the new row is completely blank instead of having the formulas copied in?!
vague i know, sorry!

thanks for any help?

millsy

**Cheeky Charlie** · 08-27-2008, 08:01 AM

Why not copy the rows and insert them?

The alternative is to select the used cells in the last filled row and double click the anchor in the corner. (little black square box)

HTH

**NBVC** · 08-27-2008, 08:12 AM

Originally Posted by rjmills18

hi
is there a way which my formula chains can be updated when inserting rows? i.e. the calculating formulas that run down my columns, are broken when a new row is inserted, that is, the new row is completely blank instead of having the formulas copied in?!
vague i know, sorry!

thanks for any help?

millsy

If you have Excel 2003 or 2007, you can use the List Feature (in 2003) or Table feature (in 2007)...

These will convert your data into a self contained table... and when you add a row, the formulas will automatically copy down.

Here are some instructions...

http://www.j-walk.com/SS/excel/xl2003.htm

http://office.microsoft.com/en-us/ex...33.aspx#Tables

**rjmills18** · 08-27-2008, 08:18 AM

thanks for your help guys!
i had the data in a list before but then had issues with protecting the formulas, if i put it back in a list can i protect these formula chains??!!

thanks again