Rachel has attended:
Excel Intermediate course
Word and Excel
I am trying to paste links from excel to word. What are the differences amongst various types of 'paste special?'
RE: Word and Excel
Hi Rachel,
If you paste special as HTML format, any hyperlink created in Excel will stay with the pasted text, and you'll be able to click the link in Word. If you paste special as Unformatted text, the pasted text will appear as text only, not as a hyperlink.
Below are the other types of Paste Special.
I hope this helps. If it does, please mark this question as resolved.
Regards, Rich
Microsoft Excel Worksheet Object
Inserts the contents of the Clipboard into your document so that you can edit it using Microsoft Excel Worksheet.
Formatted Text (RTF)
Inserts the contents of the Clipboard as text with font and table formatting.
Unformatted Text
Inserts the contents of the Clipboard as text without any formatting
Picture
Inserts the contents of the Clipboard as a picture. This format is better than Bitmap for printing to high quality printers. Of the format options available, Picture occupies the least space on disk and displays the quickest in Word.
Bitmap
Inserts the contents of the Clipboard as a bitmap picture. This format can take up a lot of memory and disk space, but is exactly what you see on the screen.
Picture (Enhanced Meta file)
Inserts the contents of the Clipboard as an enhanced meta file.
HTML Format
Inserts the contents of the Clipboard as HTML Format.
Unformatted Unicode Text
Inserts the contents of the Clipboard as text without any formatting.