Paste Special in Microsoft Word

Thursday, July 20th, 2006 at 9:22 AM | 6 comments Category: Features

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.

Subscribe: RSS or E-mail

6 comments

  • Posted by: Jerome Delacroix on January 29th, 2007, 6:24 AM

    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

  • Posted by: Katy on March 15th, 2007, 7:26 AM

    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.

  • Posted by: Meryl on March 15th, 2007, 7:37 AM

    Instead of a button, I have text that says “No format.” Not pretty, but does the job.

  • Posted by: Andy on April 8th, 2007, 9:25 PM

    Great tips. Many thanks.

  • Posted by: ed lenert on August 17th, 2007, 11:58 PM

    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?

  • Posted by: Vivian on July 10th, 2008, 2:05 PM

    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!

Post a comment (or leave a trackback)

RSS Subscribe to be notified when new comments are added.