Connie

Do your formulas meet the criteria from help

Extend list formats and formulas Select to automatically format new items
added to the end of a list to match the format of the rest of the list.
Formulas that are repeated in every row are also copied. To be extended,
formats and formulas must appear in at least three of the five last rows
preceding the new row.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Connie Martin" wrote in message
...
I have XL2000. I checked out Tools/Options/Edit and the check mark is in
"Extend list formats and formulas". Still doesn't work. What gives?

"Nick Hodge" wrote:

Connie

If you have XL2003 you could set this up as a list (DataList...) this
will
autofill formulas
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Connie Martin" wrote in message
...
Why do I always have to drag down a formula in rows of data. I am
filling
in
data now on row 1,464 and I still have to drag down the data in certain
columns. Why will it not auto-complete? For example, in one column I
have
this formula:
=IF(I1463="","",VLOOKUP(I1463,SHIPTO,2,FALSE)). It remains blank even
when
the cell in column I is typed in. I have to drag down the formula from
the
preceding row. It's frustrating and slows down productivity!! Any
suggestions?

Connie Martin