Auto formula fill
 

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

Auto formula fill
 

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

Auto formula fill
 

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

Auto formula fill
 

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

Auto formula fill
 

Yes, that option is selected. Some formulas copy down automatically, some
don't. I am on row 1473 now in the spreadsheet. Makes no sense that some
columns I always have to manually drag down while others auto-complete.



"Nick Hodge" wrote:

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

Auto formula fill
 

Looks like the answer could be he http://support.microsoft.com/kb/231002

"Nick Hodge" wrote:

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