Combining formulas from difffernt cells

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
 
A

AdamV

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top