Copying total, not formula

P

pjamorton

Hello All, please forgive me if this is a stupid question, but is
there a way to copy and paste the result of a formula and not the
formula? For example, if the the cell has a formula of "=A1+B1" and
the result is 2, how do I copy the "2" not the actual formula? Hope
this makes sense. Thanks in advance!! Jen
 
A

Alan

Right click the cell and 'Copy'. Select the cell you want to paste the value
into, right click, 'Paste Special', check ,'Values' and click OK,
Regards,
Alan.
 
P

pjamorton

Right click the cell and 'Copy'. Select the cell you want to paste the value
into, right click, 'Paste Special', check ,'Values' and click OK,
Regards,





- Show quoted text -

That makes sense, thank you!!
 

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