Typing a formula in a new column and having the formula automatically
repeated down the column has never been a built-in feature of any version of
Excel.

There is no setting turned off that can be turned back on.

Perhaps you had some event code that did the automatic fill down?

If the new column is adjacent to a filled column, double-click on the fill
handle of cell you just entered the formula into.


Gord Dibben MS Excel MVP

On Tue, 3 Nov 2009 06:21:02 -0800, William McNeill
wrote:

I have a spreadsheet which imports data from Access. The Access data changes
weekly, and I then go into the spreadsheet and refresh the tables. In the
tables, I could at one time type in a new formula in a new column and it
would automatically repeat this formula down the entire column the whole
length of the table. Somehow I must have turned this function off, and I can
not figure how to turn it back on. Excel 2007. Please help, thanks!!!!