Stan:
Tools | Options | Edit; check the box Extend Data Range Formats and Formulas
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Stan Brown" wrote in message
t...

If you are using Excel 2003, the formulas will be automatically insert if
you have a table with about 5 rows of formulas.

Really? I have a couple of worksheets that are long columns of
formulas, and have to insert the formulas manually when I add rows.
Is there some option I should set?

--