| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill of formulas
I have some spreadsheets that will automatically copy the formula above when
data is entered in the cell to the left of the cell where the formula is needed. I can't find how this feature is turned on....... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill of formulas
wpm wrote:
I have some spreadsheets that will automatically copy the formula above when data is entered in the cell to the left of the cell where the formula is needed. I can't find how this feature is turned on....... It sounds like a Worksheet_Change event procedure. Is the code in that worksheet's code module? If not then you will have to copy/paste from a sheet that does have the code. Have macros been enabled when the workbook was opened? Are Events enabled, or has a previous error turned events off without turning them back on? Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill of formulas
Perhaps ToolsOptionsEditExtend Data Range Formats and Formulas?
About half the time it doesn't work for me but I get surprised on occasion<g Gord Dibben MS Excel MVP On Wed, 20 Sep 2006 12:57:01 -0700, wpm wrote: I have some spreadsheets that will automatically copy the formula above when data is entered in the cell to the left of the cell where the formula is needed. I can't find how this feature is turned on....... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill with some references locked | Excel Discussion (Misc queries) | |||
| stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
| Auto fill color change | Excel Discussion (Misc queries) | |||
| Auto fill option box disappeared | Excel Worksheet Functions | |||
| How do I auto fill formulas | Excel Worksheet Functions | |||
Linear Mode
