Insert Formula

[Bob]

How do you insert a formula automatically in a spreadsheet when you insert a
new line?

Thanx in advance

Bob

 

[Andy Brown]

How do you insert a formula automatically in a spreadsheet when you insert a
new line?

Check out Tools -- Options -- Edit -- Extend Formats & Formulas.

Or this page http://www.mvps.org/dmcritchie/excel/insrtrow.htm.

Rgds,
Andy