Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste special default (Word 2000)

    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

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Paste special default (Word 2000)

    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:
    <pre>Sub PasteSpecialUnformatted()
    Selection.PasteSpecial DataType:=wdPasteText, Placement:=wdInLine
    End Sub</pre>

    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.

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste special default (Word 2000)

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

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste special default (Word 2000)

    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. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •