Paste Special Unformatted Text

[kenwpaul]

The one option I use most in Office documents is Paste Special Unformatted Text. I've never seen a shortcut for that. Is there any way to set up a global key combination to accomplish that? I would want it to be consistant across all of the Office products.

[macropod]

Hi Ken,

Each Office App could have a macro added to the default template (eg Normal.dotm in Word) that is activated via a keyboard shortcut. It should be possible to find an unused shortcut combo that's available across all (or at least most) applicable Office Apps.

A suitable macro for Word is:

Sub PasteUnformattedText()
' The next line is in case there's nothing in the Clipboard
On Error Resume Next
Selection.PasteSpecial DataType:=wdPasteText
End Sub

And, for Excel:

Sub PasteUnformattedText()
    On Error Resume Next
    Selection.PasteSpecial Paste:=xlPasteValues
End Sub

If you prefix the subs with 'Private', they won't show up in the macros list.

[kenwpaul]

Thanks, Paul. That looks promising.