Shortcut in Word or Excel for Special Paste?
If I want to paste without any formatting, I have to go to the "Paste" button on the ribbon and click "Paste Special" and then "unformatted text".
Is there a shortcut like Ctrl+V that'll automatically do that for me?
On Word 2007 to 2013 on Windows, you can use Ctrl+Alt+V.
On Word 2011 for Mac, you can use Control+Command+V.
Both of these will bring up the "Paste Special" dialog. There's no shortcut directly for "Unformatted Text", but since you can use arrows to go to "Unformatted Text" and Enter to confirm, this is probably the fastest way without a macro.
I've just found out that in Word 2013 and Excel 2013 there is a quick way to access, from keyboard, all the "Paste Special" options. In the following examples it is just shown how to paste as text (without pasting the formats).
Word 2013:
After having copied something go where you want to paste it (without pasting the format). CTRL+V (it will temporarily paste the format too) then CTRL (push and release the control key) then T (the last T means "keep text only").
Excel 2013:
After having copied something go where you want to paste it (without pasting the format). CTRL+V (it will temporarily paste the format too) then CTRL (push and release the control key) then V (the last V means "paste Values").
It's important that the second CTRL key is released before typing the last letter.
This method requires just 4 keyboard hits, no macros and no use of the mouse in a dialog window.
I don't think there is, but the good news is that you can make one by creating a macro.
Either record the macro, doing the paste the way you want to, then assign it to a keyboard shortcut, or put the following into a new macro (assuming you want to paste without formatting):
For MS Word 2010:
Selection.PasteAndFormat (wdFormatPlainText)
For MS Excel 2010:
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False, NoHTMLFormatting:=True
Again, once you've saved the Macro, you'll need to assign it to a keyboard shortcut (eg ctrl + m).
Addition: MS Word 2002:
Sub PastePlaintext()
Selection.PasteSpecial Link:=False, DataType:=wdPasteText
End Sub