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


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

<div>
Do you just want this in C2<br />
<br />
=SUM(A2,B2)<br />
<br />
regards, barry
</div>


Do you just want this in C2

=SUM(A2,B2)

regards, barry

<div>
There's no shortcut to perform this action via keyboard or mouse click. &nbsp;You have to do this via a formula:<br />
in Cell C1 enter &quot;=A1+B1&quot; &nbsp;or &quot;=CONCATENATE(A1,B1)&quot;
</div>


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)"

<div>
ctrl and c<br />
<br />
right click paste special &gt;&nbsp;value<br />
<br />
done
</div>


ctrl and c

right click paste special > value

done

<div>
<div class="content wysiwyg-content">
<br />
Cell a + cell b = Cell C. <br />
<br />
I cant ctrl C or right click and copy. <br />
Is there a way?<br />
Thanks <br />
&nbsp;
</div>
</div>



Cell a + cell b = Cell C. 

I cant ctrl C or right click and copy. 
Is there a way?
Thanks 
 

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.