Repeat Formula

[annonymous]

As an example: I want the formula of adding figures from Col. A to figures
in Col. B to always appear in Col.C from line 1 to infinity.

At present I am using copy and paste for every line but I am sure there
must be a way of producing the result automatically every time an entry in
the line is made.

How do I do it?

Thank you.

 

[Norman Harker]

Hi!

Select Column C
In Formula bar type =A1+B1
Press and hold down Ctrl
Press Enter

I can't say I'd advise use for an entire column because it will soon
blow out the size of the workbook having all those formulas that are
unused. Better would be to select the expected range and use the same
process.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Niek Otten]

Tools>Options>Edit, check "Extend data range format and formulas.
From Excel Help: To be extended, formats and formulas must appear in at
least three of the five list rows preceding the new row.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel