Should this happen automatically?

Yes it should. But it doesn't happen when you insert the row, but rather it
happens after you enter the data in the new row.

--
Jim
"BillyV" wrote in message
...
When I add new lines to expand a worksheet, existing formulas do not
extend
to the new lines. I have the Tools/Options/Edit 'Extend List Formats &
Formulas' box checked. Should this happen automatically?