Combining formulas from difffernt cells

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

I am using Excel 2002. In cell A1 I have a long formula, and in cell
A2 another long formula. How can I copy the formula in cell A2 and
then add the formula to cell A1 so it has its formula plus [+] the
formula in A2?

Thanks,

Tonso
 
Go to the formula bar and select the formula in there, then CTRL-C to copy,
go to the other formula and paste (CTRL-V) it in where you need it (again in
the formula bar)

You could do this with keys by hitting F2 (edit in cell) Shift-Home (to
selct all content, Ctrl-C (copy), Esc (stop editing). Then Paste as usual.
 
Back
Top