Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

training in excel - word and excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Word and Excel

training in excel - Word and Excel

ResolvedVersion Standard

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.

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.