Meryl's Notes Blog
Things wordy, geeky, and webbyPaste Special in Microsoft Word
Thursday, July 20th, 2006 at 9:22 AM |Once I got out of automated mode, I woke up and realized that I often use Paste Special with unformatted text when working in MS Word. It became a habit like CTRL+V, CTRL+X, and CTRL+C. To do Paste Special without formatting, I clicked CTRL+V to paste, selected the Paste Special icon (smart tag) and selected Keep Text Only. Another way to do a Paste Special is to click Edit, Paste Special and select your preference.
Why do all that when I can create a macro and put a button on the toolbar? That’s exactly what I did. It took a few days to get the hang of using the button instead of going the old-fashioned route. I can’t remember where I found the tip and searching for it didn’t jog my memory.
A Microsoft article shows part of the way. The difference is that it changes CTRL+V to paste unformatted text. There are occasions when I do want it to paste formatted text, so I don’t want to change CTRL+V. The button works great. I had thought about making another keyboard shortcut, but I didn’t want to risk erasing another shortcut in the process.
If you prefer to create a keyboard shortcut, here are the Windows keyboard shortcuts. However, these don’t consider the shortcuts that come with specific programs like SnagIt. I use CTRL+SHIRT+P to snag an image.
Here are the steps from the Microsoft article with some minor changes:
1. Start Word.
2. Click ALT+F8.
3. In the Macro name box, type PasteUnformattedText.
4. Make sure that All active templates and documents is displayed in the Macros in list, and then click Create. The Microsoft Visual Basic Editor appears.
5. Directly above the End Sub statement in the Sub PasteUnformattedText() section, type (or copy and paste) the following line of code:
Selection.PasteSpecial DataType:=wdPasteText
6. Click ALT+Q to return to Word.
The next steps add a button to the toolbar.
1. Right-click the toolbar and select Customize.
2. Ensure the Commands tab is selected.
3. Select Macros and locate Normal.NewMacros.PasteUnformated.Text (part of it might be cut off).
4. Click and hold Normal.NewMacros.PasteUnformatedText and drag it to where you want it in the toolbar.
5. Right-click Normal.NewMacros.PasteUnformatedText (if nothing happens, click the Customize window and right-click again — keep the Customize window open).
6. Change Name to whatever you want, so you can shorten it.
You can use an image instead, if you prefer. In this case, while the Customize window is still open:
1. Right-click the new button you created, select Change Button Image, and pick an icon.
2. Right-click the button again and select Default Style. Only an image appears. You can leave it as image and text, if you prefer.
You might want to do a Save All after finishing this. See this post for an explanation and how to do it.
Search and archives
Get Updates
-
Categories
Archives
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
-
Other Stops
-
Connect with Meryl
-
Recommended
Blogroll
All Content © Copyright 2010 Meryl.net. This work is licensed under a Creative Commons License.
Privacy Policy | Thanks to Blue Flavor and Fireside Media for WordPress Consulting | Valid XHTML and CSS
14 comments
Great tip. I use Word all the time and I had been looking for this for a long time.
Thanks for the time saved!
Jerome
This is great thanks, any one able to find any button images for edit paste special on the change button menu I couldn’t find anything suitable.
Instead of a button, I have text that says “No format.” Not pretty, but does the job.
Great tips. Many thanks.
Attention!
The fact that it takes all that work to make MS Word paste plain text is a living monument to the stupidity of MS Programers.
Do you all reaslize just how complex these instructions are? And how you really couldn’t figure this out for yourself?!
MS Word is hard to use, and after 10 tries the programmers are making it harder and not easier to use.
Office should not be a monopoly.
Why couldn’t I just ask Mr. Paperclip to help me past plain text … oh, yeah?
Does anyone know how to change the “right-click paste” menu in Word so that when you choose Paste, it will automatically paste in unformatted text only? I don’t want to give my users the ability to paste text in formatted from the right click menu in Word 2003. Thanks, any help is appreciated!
You have no idea how much easier you just made my life. Thank you so much for the easy, clear instructions!
I’ve been using a button in Word for many versions, including 2007, but how is it done with a button/macro in Outlook 2007? The macro (VB) code isn’t the same!
This doesn’t work with 2007. Instead, you’ll need to add a shortcut for Paste into the quickbar and use that. It’s not as fast or elegant as this situation, but it’s the next best thing I’ve found so far. Anyone have a better solution for 2007?
Cool simple macro, but it won’t work when trying to replace selected text. With one small modification, it works better. Call ‘Selection.Delete’ before the paste function, like this:
Sub PasteUnformattedText()
Selection.Delete
Selection.PasteSpecial DataType:=wdPasteText
End Sub
Ooops. Don’t use the previous entry suggestion. Use this instead.
Sub PasteUnformattedText()
If Selection.StartIsActive Then
Selection.Delete
End If
Selection.PasteSpecial DataType:=wdPasteText
End Sub
Thanks, Brian. People will appreciate your making it better.
I’d strongly recommend this solution. Just watch video tutorial to easily complete the task:
http://www.myhowtoos.com/en/excel-howtoos/83-how-to-paste-as-unformatted-text-using-a-shortcut-in-ms-word
In response to Katy, asking about an appropriate button: In Word 2003, the right-click drop-down menu (that you see when toolbar customization is active) has options to copy, paste, and edit button images. The editor is an error-prone, one-pixel-at-a-time editor, but it’s usable. I used it to copy the ordinary Paste button and put a giant, red letter “U” for “Unformatted” over it.
Post a comment (or leave a trackback)