Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. The following VBA code can help you to change the default paste to paste values.ġ. When you paste the data as values only, you need to click the little square at the corner of your selection and choose Values option each time after pasting the data.
Set paste values as default paste when using Ctrl + V with VBA code Here, I can introduce you an easy method to set the paste values only as default paste when you using Ctrl + V in Excel. But, sometimes, you just want to paste as values without any formatting when you paste the data. Normally, in Excel, when you copy data from one range or worksheet and paste with Ctrl + V to another, the formatting will be pasted as well by default. How to set paste values as default paste when using Ctrl + V in Excel?
