| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling adjacent formulas with data import
Hi all,
XL2003 2nd posting - first on ended up in the ether... I've tried importing a .txt file (from the Data menu) with the "Fill down formulas in columns adjacent to data" box ticked. But my formulas don't fill. I've tried them on the left, and on the right (of the imported data), but no progress. Can anyone tell me what I may be doing wrong? Regards - Dave. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling adjacent formulas with data import
Double click the Fill Handle
http://www.ozgrid.com/Excel/excel-fill-handle.htm -- Regards Dave Hawley www.ozgrid.com "Dave" wrote in message ... Hi all, XL2003 2nd posting - first on ended up in the ether... I've tried importing a .txt file (from the Data menu) with the "Fill down formulas in columns adjacent to data" box ticked. But my formulas don't fill. I've tried them on the left, and on the right (of the imported data), but no progress. Can anyone tell me what I may be doing wrong? Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data, fill adjacent formulas | Excel Discussion (Misc queries) | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| Import External Data -- Fill down formulas Issue | Excel Worksheet Functions | |||
| How do I import data onto formulas in an excel template? | Excel Discussion (Misc queries) | |||
| How do I import data from lotus123 & maintain formulas/worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
