Formula autofill with new records

[The Farmer]

I have a spreadsheet with records that contain several formulas. I set
Excel to "Extend list formats and
formulas" so that when I type on the next blank row, the formulas will
automatically fill in. My problem is that only some of the formulas get
copied to the new records.

Does anyone know how the autofill feature works, or where I can find out
more? TIA

 

[Jim Rech]

Here's a description of how this feature is supposed to work:

http://support.microsoft.com/default.aspx?scid=kb;en-us;231002&Product=xlw

--
Jim Rech
Excel MVP
|I have a spreadsheet with records that contain several formulas. I set
| Excel to "Extend list formats and
| formulas" so that when I type on the next blank row, the formulas will
| automatically fill in. My problem is that only some of the formulas get
| copied to the new records.
|
| Does anyone know how the autofill feature works, or where I can find out
| more? TIA
|
|

 

[David McRitchie]

Hi Farmer,
I have "extended formulas" on like you but don't rely on it a lot.
I use a macro to insert rows, which inserts rows and
copies the entire row with the active cell down into the
inserted rows and removes constants leaving formulas.

See http://www.mvps.org/dmcritchie/excel/insrtrow.htm