formula copying

  • Thread starter Thread starter Wilfried
  • Start date Start date
W

Wilfried

I have a column A en B. In column C I have put the formula =A1+B1.

When I go to next row, to my surprise, as soon as I have filled in columns A
and B, the results shows immediatly in C. How come?

Regards from Aartselaar (B)
Wilfried
 
Hi Wilfied,

You have Tools>Options>Edit, "Extend data range formats and formulas"
checked

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Hi
this is an option in 'Tools - Options - Edit'. Should read something
like 'Extend list/formula'
 
Back
Top