| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to auto fill in following month. | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Auto Extended Formula not working | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Linear Mode
