| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically fill in formula
I thought that this was done automatically but ...
I have a sheet with a list of customers and how much they purchased. The sheet is to be given to the accountant to be billed. The sheet has about 8 columns some I fill in and others with formulas. The first column is the date, after that I have 2 seperate columns that have the formula for the year and month. 3 more columns of data that I fill in and then formulas... I thought that Excel recognized that as soon as there was data in adjacent columns it would add the formulas automatically... For some reason I need to copy and paste or drag the formulas down the column.. Is there somewhere to make this happen automatically? I am using Excel 2000 on a terminal server... Thanks for any help. Stan |
| 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) | |||
| Cell Ref. in Formula changes automatically | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
