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