PaulSpoerry.com

Social Media, technology, and geeky stuff for your brain.

  • Home
  • About
    • Privacy Policy
  • Categories
    • Google+ Posts
    • Site news
    • Tech
      • Android
      • Apple
      • Chrome
      • Gadgets
      • Hacking
      • Linux
      • OSX
      • Privacy
      • Web Life
        • Bittorrent
        • Facebook
        • FireFox
        • GMail
        • Google
        • Google+
        • Twitter
        • WordPress
        • Windows
          • Windows 7
    • Google+: Getting Started Guides
    • Games
    • Meditation
    • Politics
    • Science
    • That’s freakin hilarious
  • Code
    • FreeImageZoom
    • Post Editor for Google+™
    • The Plus Editor
  • Contact
You are here: Home / Tech / Paste Special As Unformatted text – must DIE

Paste Special As Unformatted text – must DIE

February 13, 2007 by Paul Spoerry 2 Comments

I have a serious, SERIOUS issue with the fact that everything I paste into any document always retains the format of the place I copied it from. Drives me outta my mind. Visual Studio has special formatting… so if I paste it into a business or technical design document it throws off the formatting of the document. If I copy something from the Internet, it throws off the formatting. I can’t tell you how sick I am of typing Paste Special as unformatted text – by default this action requires using your mouse too… no keyboard shortcut. Check this out, I lifted it straight from Microsoft and you can see it on their page if you want to see the original text.

When you copy and paste formatted text into a Microsoft Word 2002 document, the Paste Options smart tag appears, which provides an option to paste the text without the formatting. This is handy if, for example, you don’t want to mix formatting styles in your document.

However, there are a couple of reasons why you might not want to use the Paste Options smart tag. First, if you’re like me, you frequently use the keyboard to copy (CTRL+C) and paste (CTRL+V) text. This means that to use the Paste Options smart tag, you must remove your hand from the keyboard, use the mouse to click the Paste Options smart tag and select an option, and then return your hand to the keyboard to continue working. If, like me, you do this operation a couple of dozen times a day, it can represent a substantial interruption in your work flow. Second, the Paste Options smart tag isn’t available in earlier versions of Word. You could use the Paste Special option on the Edit menu to paste unformatted text, but then you are back to using extra mouse clicks.

Create and run the macro

First let’s create the macro, which will allow us to paste unformatted text from the Clipboard into your documents. If you’ve never created a macro before, this one provides both a good learning experience and a useful function.

To create the macro to cut and paste without formatting

  1. Start Word.
  2. On the Tools menu, point to Macro, and then click Macros to display the Macros dialog box.
  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 is displayed.Note: If you need to learn about the Visual Basic Editor, see the Power User Corner column Managing Macros with the Visual Basic Editor.
  5. Directly above the End Sub statement in the PasteUnformattedText�subroutine, type the following line of code: Selection.PasteSpecial DataType: =wdPasteText
  6. On the File menu, click Close and Return to Microsoft Word.

Now you need to instruct Word to run the PasteUnformatedText macro each time you press the CTRL+V keyboard shortcut.

To run the macro each time you press CTRL+V

  1. On the Tools menu, click Customize.
  2. Click the Keyboard button.
  3. Make sure the Save changes in box displays Normal.dot.
  4. In the Categories list, click Macros.
  5. In the Macros list, click PasteUnformattedText.
  6. Click in the Press new shortcut key box, press and hold the CTRL key, and then press and hold the V key at the same time. The Press new shortcut key box displays Ctrl+V.
  7. Click Assign. Click Close and then click Close again.

That’s it! Now, every time you press CTRL+V, Word pastes text from the Clipboard without the formatting.

If you ever want to return the CTRL+V keyboard shortcut to its default behavior, it’s very easy to do.

To return the CTRL+V shortcut to its default behavior

  1. On the Tools menu, click Customize.
  2. Click the Keyboard button.
  3. Make sure the Save changes in box displays Normal.dot.
  4. In the Categories list, click Macros.
  5. In the Macros list, click PasteUnformattedText.
  6. In the Current keys box, click Ctrl+V and then click Remove.
  7. Click Close, and then click Close again.

The CTRL+V keyboard shortcut now pastes text and any formatting from the Clipboard by default. However, the PasteUnformattedText macro is still available if you ever want to use it again.

Filed Under: Tech, Windows Tagged With: microsoft, paste, special, text, unformatted

About Paul Spoerry

I’m a groovy cat who’s into technology, Eastern Thought, and house music. I’m a proud and dedicated father to the coolest little guy on the planet (seriously, I'm NOT biased). I’m fascinated by ninjas, the Internet, and anybody who can balance objects on their nose for long periods of time.

I have a utility belt full of programming languages and a database of all my knowledge on databases... I practice code fu. Oh, I've also done actual Kung Fu, and have a black belt in Tae Kwon Do.

I run. I meditate. I dance. I blog at PaulSpoerry.com, tweet @PaulSpoerry, and I'm here on Google+.

I'm currently work for IBM developing web enabled insurance applications for IBM and support and develop a non-profit called The LittleBigFund.

Comments

  1. themaze says

    January 5, 2009 at 7:02 am

    Use ALT+SHIFT+F10 after pasting the text, my friend

  2. davide1982 says

    May 11, 2009 at 1:52 am

    Great post, thanks ! For the very beginners I’d advice watching this 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Copyright © 2023 · Epik on Genesis Framework · WordPress · Log in