Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste or Paste Special (Word XP)

    Hello everyone:

    Can anyone tell me, what is the best possible way of taking information from a Excel spread sheet, and pasting the information into a word document, the information that I am pasting is your everyday company name and address; I have tried by using the Paste special, but now that I have changed my Windows Operating Systems to XP, I don't have the option to use the Paste special, it only says (Paste). I can get the information into the word document, but I have to press delete, return just so that I can line up the information into a proper address format.

    Thanks

    dillon

  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 or Paste Special (Word XP)

    Word's Edit > Paste Special... > Unformatted is the best method for doing what you describe (i.e., you don't want to preserve the look and feel of Excel).

    But, I don't understand how this could become disabled. Did you install Windows XP over Windows 98/ME on your system? Perhaps this has mucked up Office's understanding of the clipboard, 'though I haven't heard of that happening before. If you use the Office installer to "Detect and Repair" Office, perhaps this will be straightened out. It's on the Help menu inside the application, or you can use the Add and Remove Programs... control panel. You might need to have your Office CD handy; sometimes the installer likes to retrieve fresh copies of things from the CD.

    Also, there is a "smart tag" that should pop up when you paste (looks like a little clipboard with a drop down arrow) right next to the end of the pasted text. This might offer you another fix for the misbehavior, but... certainly it's faster if you can get Paste Special working again.

    If you are inclined toward a macro solution, here's what I use:

    Sub PasteSpecialUnformatted()
    Selection.PasteSpecial DataType:=wdPasteText, Placement:=wdInLine
    End Sub

    I then customize my keyboard so that Ctrl+Shift+v runs this macro. (If I forget and use Ctrl+v, I undo, Ctrl+z and then run the macro, Ctrl+Shift+v).

  3. #3
    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 or Paste Special (Word XP)

    Personally, I'd recommend Alt+Ctrl+V or Alt+Shift+V. Ctrl+Shift+V is used for PasteFormat, which I find to be handy (after using Alt+Shift+C to CopyFormat). You can use it to copy a style & then paste that style into odd places in a document. It's also useful when trying to correct numbering.
    Cheers,

Posting Permissions

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