EXCEL copy formulas
EXCEL copy formulas
(OP)
What did EXCEL do to copying formulas from one spreadsheet to another???
How does one get around this change?
Am I missing something very obvious?
Jim
How does one get around this change?
Am I missing something very obvious?
Jim





RE: EXCEL copy formulas
RE: EXCEL copy formulas
There are a range of Paste options available. You have to hover over the icons to see what they do, but you can paste the values only, formulas only, links only, paste with formatting included or not included. If you hit the "Paste Special" button, then I think you paste combinations of the just mentioned options.
RE: EXCEL copy formulas
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: EXCEL copy formulas
Thanks for the assistance.
Jim
RE: EXCEL copy formulas
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: EXCEL copy formulas
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: EXCEL copy formulas
Thanks to all who made suggestions.
Jim
RE: EXCEL copy formulas
RE: EXCEL copy formulas
Read over the following two links. They should help clear things up.
https://support.microsoft.com/en-us/help/917637/yo...
https://excel.tips.net/T003404_Copying_Between_Ins...
RE: EXCEL copy formulas
RE: EXCEL copy formulas