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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically fill in formula
Maybe...
Tools|Options|Edit tab|Check "Extend data range formats and formulas"???? Stan wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically fill in formula
Thanks Dave for your help.
I checked the tab and it was checked.. What I saw happen now when I put a new date in it added the formulas for month and year... I added the info in the following 3 columns, but it did not add the formulas for the next adjacent column... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically fill in formula
I turn that setting off. I find that I don't understand the rules that it
uses. I always copy and paste. If you want a macro that may do what you want, visit David McRitchie's site: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Stan wrote: Thanks Dave for your help. I checked the tab and it was checked.. What I saw happen now when I put a new date in it added the formulas for month and year... I added the info in the following 3 columns, but it did not add the formulas for the next adjacent column... -- Dave Peterson |
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) | |||
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) |