 |
 | 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 / New Users / September 2004copy formulas
I have a excel worksheet that i want to copy the data and the formula to a new worksheet .The worksheet was linked not embeded so it won work without the link. When i try to copy it i only get the data not the formulsa . Any help would be a great help Replace all equal signs with r=, copy what you want, then reverse the replace, i.e. edit>replace>find what =, replace with r= copy and paste edit>replace>find what r=, replace with =  SignatureRegards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) > I have a excel worksheet that i want to copy the data and the formulas > to a new worksheet .The worksheet was linked not embeded so it wont > work without the link. > When i try to copy it i only get the data not the formulsa . > Any help would be a great help. Try: Edit|Paste Special...|Formula Hope this helps. > I have a excel worksheet that i want to copy the data and the formulas > to a new worksheet .The worksheet was linked not embeded so it wont > work without the link. > When i try to copy it i only get the data not the formulsa . > Any help would be a great help. |
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.