ToolsOptionsEdit Extend data range formats and formulas.

If three or more cells adjacent to the cell have a format or a formula Excel
extends it.


Gord Dibben MS Excel MVP

On Mon, 3 Dec 2007 17:38:49 -0800, "PT" wrote:

Excel 2003 Win XP Home

I use a simple worksheet which consist of five columns into which I add four
figures of numeric data across a new successive row each day. The fifth
column includes a sum formula to sum the entries on that row's four columns.

Here's the mystery. When I enter the fourth of the data figures on a row,
the sum magically appears in the fifth column. I've checked and the sum
cell is blank prior to my entering the data figures. Somehow, Excel has
figured out that the new row should contain the same formula as the cell
immediately above.

How does this happen?