| 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 |
| 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) | |||
Threaded Mode
