Paste values without using "paste special"

[aarceng]

I fund that "paste values" is something I use a lot.
I know I can use the ribbon or right click and select but is there a keyboard shortcut I can use or customise instead?

 

[Michael M]

Ctrl + Shift + V
Also

ALT+E+S+V

 

[James006]

Hi,

You can add to your PERSONAL.XLSB file following macro

Sub PasteValues()
' PasteValues Macro
' Keyboard Shortcut: Ctrl+w
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues
    ActiveSheet.Paste
    Application.CutCopyMode = False
End Sub

 

[aarceng]

Ctrl + Shift + V
Also

ALT+E+S+V

Ctrl + Shift + V does nothing

ALT+E+S+V opens the paste special dialog box.

 

[Michael M]

ALT+E+S+V opens the paste special dialog box.

Yes it does, then just press OK.

 

[aarceng]

Hi,

You can add to your PERSONAL.XLSB file following macro

Sub PasteValues()
' PasteValues Macro
' Keyboard Shortcut: Ctrl+w
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues
    ActiveSheet.Paste
    Application.CutCopyMode = False
End Sub

Sorry, seems to do nothing. But then I'm not much good with VBA. I use spreadsheets a lot at work but macros are not to be used.

 

[aarceng]

I fund that "paste values" is something I use a lot.
I know I can use the ribbon or right click and select but is there a keyboard shortcut I can use or customise instead?

Clarification. I might have copied values from another document and want to paste values only into my spreadsheet. So assume the paste value will already be in the clipboard.

 

[aarceng]

If I had a working macro I could add it to the quick action bar, then it would be a one click solution.
What I tried was;

1. Copy a formatted cell with a value in it.
2. Selected destination cell
3. Clicked "record macro"
4. Used paste special values to paste the value only into the cell
5. Click "stop recording"
6. Result

Sub AA()
'
' AA Macro
'
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

Back to spreadsheet, copy then select destination cell, run macro and I get "PasteSpecial method of Range class failed".

 

[James006]

If I had a working macro I could add it to the quick action bar, then it would be a one click solution ....

EXACTLY ... !!! Go back to suggested solution post # 3

 

[James006]

For your info ... Precisely Like You ... I am using this feature constantly ...

I was so fed up with the lack of flexibilty ... that I designed my own macro and stored it in the PERSONAL.XLSB

So it is always available ... and also added a icon shortcut to the Quick Bar .... to avoid my Ctrl+W !!!