Change paste options

[mkingrey]

Is there a way, in excel, to set the program to automatically paste special? For instance, I use "paste value" a lot more than regular paste and it would save time to just be able to use CTRL + V rather than right click/paste special/values.

 

[Joe4]

Create it as a macro, then you can create a keyboard shortcut for it. I did that with the same function because I use it so much too.

Here is the VBA code that will take any highlighted range and copy paste special values over top of itself:

Sub MyPasteSpecialValues()
'   Copy and paste special - values, of selected range
'   Shortcut CTRL-SHFT-V

    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    ActiveSheet.Paste
    Application.CutCopyMode = False

End Sub

Then go to Tools | Macro | Macros, highlight the "MyPasteSpecialValues" macro, select Options and set your keyboard shortcut.