Link to home
Start Free TrialLog in
Avatar of fcek
fcekFlag for Ireland

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?
Avatar of StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Use a formula? Don't think you can copy two cells and paste the sum (without VBA anyway).
Avatar of barry houdini
Do you just want this in C2


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)"
Avatar of Let's Go
Let's Go
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fcek


ctrl and c

right click paste special > value