The following MSKB article explains how Auto Extend works, and some of
the reasons that it may not work:


XL2000: How Auto Extend List Behavior Works
http://support.microsoft.com/?id=231002


DippyDawg wrote:
I am looking for a way to have formulas and cell formats from preceeding rows
automatically entered into inserted rows. I have the Extend formats and
formulas option checked but it is not working?????


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html