auto fill of formulas

W

wpm

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.......
 
K

Ken Johnson

wpm said:
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.......
Click to expand...

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
 
G

Gord Dibben

Perhaps Tools>Options>Edit>Extend 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
 
Top