Excel 2010 v 2013 - Paste functions

Excel 2010
Excel 2013

In 2010 when I copy a series of cells that contain numbers in one worksheet, and then Paste (using Ctrl+V or right mouse click and Paste) the number values are pasted into the second worksheet.

In 2013 when I copy a series of cells that contain numbers in one worksheet and then Paste (using Ctrl+V or right mouse click and Paste) the cells in the second worksheet are filled with zeroes.  To paste the actual numbers I have to right click and choose Paste Values.

Is there a setting in the Options that will make 2013 work like 2010, or was that a change made by MS and we have to live with it.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kanti PrasadCommented:

It appears Excel 2013 has the paste  options  viewable.

If you go to File, Options, Advanced settings go to cut copy and paste section and see that show paste options is clicked.
Then when you paste you will get the options to select values, formulas etc
LindahqAuthor Commented:
It seems neither of you read the description of my issue.  I know how to Paste.  I know what the Paste options are.  The issue is:

In 2010 the program defaulted to Pasted Values.  In 2013 it does not.  Can 2013 be changed?
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Roy CoxGroup Finance ManagerCommented:
I don't think you can change the default paste action. I find right clicking on the destination cell and choosing Paste values simple enough. Alternatively you can add a Button the Quick Access ToolBar.

Right Click on the Ribbon and choose Customize Quick Access Toolbar
Choose Commands not on Ribbon
Scroll down and find Paste Values, highlight it and click Add
Rory ArchibaldCommented:
2010 did not default to paste Values unless you were pasting between separate instances of Excel. 2013 behaves the same as 2010 - if you copy between instances, you will get values. The difference is that 2013 looks like it is using separate instances by default when it is in fact not.
Kanti PrasadCommented:

Just to be clear, I meant that there appears to be no option to set to copy only values as default as I did not find anything in the advanced setting that you can default it to.  The only option available is to view so that you can select only values to be copied.

LindahqAuthor Commented:
Rory Archibald - in 2010 I am copying from one instance to another.  How do I set this in 2013?
Rory ArchibaldCommented:
You need to Alt+click the Excel icon to open another instance (I think - it could be Shift+Click, I can never remember).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LindahqAuthor Commented:
Rory  the Alt+ worked great.  Is there a way to edit the Registry so that it separate instances are always opened?
Rory ArchibaldCommented:
I don't know, to be honest. (Not something I would ever want)
LindahqAuthor Commented:
Very clear and concise
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.