 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Copying total, not formula
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. > 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, [quoted text clipped - 10 lines] > > - Show quoted text - That makes sense, thank you!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.