Page 99 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 85

WORKING WITH EXTERNAL DATA 5

The paste options in the Paste Special dialog bitmap into the worksheet. The following
box vary depending upon the original source of table lists some of the most common paste
the copied data. For example, if you copy a options for the Paste Special dialog box.
picture on a Web page, you can only paste a PA

PASTE OPTION DESCRIPTION
Bitmap Pastes the selected picture as a bitmap image in the worksheet.
HTML Pastes the selected data in HTML format.
Microsoft Word Uses OLE to paste the selected data in an object that you can modify
Document Object using Microsoft Word commands.
Picture (Enhanced Metafile) Smaller than a bitmap, this format pastes the selected data as a picture.
Text Pastes the copied data as text only. Any formatting that existed in the
original data does not transfer to the Excel cells.
Unicode Text Pastes the copied data using Unicode characters. Unicode is a character
set that you can use with nearly every written language in the world.
Hyperlink Inserts the selected data with a hyperlink back to the original document.
When you click the hyperlink, the original document opens.

Text

■ The Paste Special dialog Á Click the format of the ■ Excel pastes the data into
box displays. data you want to paste. the selected cell.
ˇ Click the Paste link option ‡ Click OK.
to create a link to the original
document.
■ You can click the Paste
option if you do not want to
create a link. 85