Paste Special Aggravation · Jan 06, 05:21 PM
You would think that by what feels like the 100th iteration of Microsoft Office that Bill and co. would have figured out that pasting text without formatting is a pain in the butt. There is no keyboard shortcut, even the Ctrl-Shift-V combo only brings up the paste special menu. Finally, after reformatting some old policies I got frustrated enough to do something about it. Google showed a number of solutions but the most elegant imho was on the M$ power user site.
Create a new macro called PastePlain and paste the following just before the End Sub in the new macro:
Selection.PasteSpecial DataType:=wdPasteText
Click “Close and Return to Microsoft Word” and then follow these directions from the site:
-On the Tools menu, click Customize.
-Click the Keyboard button.
-Make sure the Save changes in box displays Normal.dot.
-In the Categories list, click Macros.
-In the Macros list, click PastePlain.
-Click in the Press new shortcut key box, press and hold the CTRL and Shift keys, and then press and hold the V key at the same time. The Press new shortcut key box displays Ctrl+Shift+V.
Click Assign. Click Close and then click Close again.
The Microsoft directions show you how to set it to Ctrl-V but why would you? Set it to a different key combo and then you can use either as the situation dictates!
— Sean Heuchert
Comment
Commenting is closed for this article.