View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dim syniad Dim syniad is offline
external usenet poster
 
Posts: 1
Default Keyboard Shortcuts for Paste Special Values and Formats

You could always Ctrl+C to copy and create a record a macro for
EditPasteSpecialValues and assign it to Ctrl+Z key for example. Or cut and
past the following code

Sub pastespecialvalues()
'
' pastespecialvalues Macro
'
' Keyboard Shortcut: Ctrl+z
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub


"Scott" wrote:

Hello,

Are there keyboard shortcuts for the commands below? I use these commands
frequently so I'd like to find a way to be more efficient.

Need short-cuts for:
Paste Special -- Values
Paste Special -- Formats

Thanks,
Scott