Paste or Paste Special (Word XP)

Topic

New Reply

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

Reply | Quote

Replies

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).

Reply | Quote

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,

Reply | Quote

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,

Reply | Quote

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).

Reply | Quote