Copying total, not formula

  • Thread starter Thread starter pjamorton
  • Start date Start date
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
 
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.
 
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

Back
Top