Paste special default (Word 2000)

Topic

New Reply

In Word and Excel 2000 Edit – Paste Special defaults to HTML format, which I find pretty useless. Is there any way to make Edit – Paste Special default to Unformatted text? Any help is greatly appreciated.
Jack

Reply | Quote

Replies

I think the Paste Special dialog shows you the format that Word would have used if you had just used Edit>Paste.

The best way around this is to create a tiny macro and give it an underused key combination like Ctrl+Shift+v (at least in Word; not sure Excel has a customizable keyboard). This is mine:

Sub PasteSpecialUnformatted()
Selection.PasteSpecial DataType:=wdPasteText, Placement:=wdInLine
End Sub

I believe there have been some other threads on this issue suggesting that you replace Edit>Paste itself with something like this. Since I do paste in pictures reasonably often, that wasn’t practical for me, but if you wanted to do that, changing the name of the macro to EditPaste would do it.

Reply | Quote

Thanks for the tip! I will try the macro as you suggested.
Jack

Reply | Quote

Hi Jefferson:
For what it’s worth, I use Ctrl+Shift+V frequently. You can copy formatting (Ctrl+Shift+C) & perform intervening steps & still be able to paste the formatting in the document using Ctrl+Shift+V.

Reply | Quote