fcek

asked on

# Excel 2007 - How to copy the sum of two two amounts?

Cell a + cell b = Cell C.

I cant ctrl C or right click and copy.

Is there a way?

Thanks

Use a formula? Don't think you can copy two cells and paste the sum (without VBA anyway).

Do you just want this in C2

=SUM(A2,B2)

regards, barry

=SUM(A2,B2)

regards, barry

There's no shortcut to perform this action via keyboard or mouse click. You have to do this via a formula:

in Cell C1 enter "=A1+B1" or "=CONCATENATE(A1,B1)"

in Cell C1 enter "=A1+B1" or "=CONCATENATE(A1,B1)"

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

ctrl and c

right click paste special > value

done

right click paste special > value

done