keyboard shortcut for paste values for excel 2016

Now, when you copy a formula from this or any other workbook, you can use the keyboard shortcut Ctrl + V to Paste Values Only in this workbook: xlsm.Īfter you minimize or close the Visual Basic Editor, click on the Macros option of the Developer tab, select your macro, click on Options, enter a 'v' in the box and click OK: You will see that the extension of your workbook has changed from. Selection.PasteSpecial Paste:=xlPasteValuesĬlick on the save button and you will get this warning:Ĭlick on 'No' and then when the Save As box appears, make sure you choose the Save As Type as a Macro Enabled Workbook: I'll use PasteasValue (NOTE: no spaces are allowed!).

Type in the name that you want to call this macro and click on OK. Then click in the Module and on the Insert menu choose Procedure. Now, select your workbook name, go to the Insert menu option and choose Module. This will bring up the Visual Basic Editor: Now, go to the Developer tab and click on Visual Basic: Then click on the box next to Developer and click OK. If you don't, just right-click anywhere on the Ribbon and choose 'Customize the Ribbon'. You will need to have the Developer tab available. In order to do that, we need to to add some VBA code to our workbook. However, in this situation the client wants all the users that have access to this file to Paste Values Only using Ctrl + V. After you copy the data you can:Ģ) you can put the Paste Values command on the Quick Access Toolbar and select itģ) you can use the keyboard shortcut Menu + V There are several ways to paste values only. However, I want to use Ctrl + V for paste values only in the second workbook. So the issue is that I want to copy data from one workbook, and paste the values only into another. When you get a preview, look for Download in the upper right hand corner. You can download the file here and follow along. It will require some VBA code to accomplish this, so make sure you have your Developer tab available (details below). In this tutorial we are going to see how to convert the keyboard shortcut Ctrl + V from Paste to Paste Values Only.

Keyboard shortcut for paste values for excel 2016