Pasting a Hyperlink

A common editing task is copying information from one source and pasting it in your workbook. By using a minor variation on pasting, you can actually cause your pasted information to appear as a hyperlink in an Excel worksheet. To paste information in this manner, follow these steps:

1. Select the information to be copied and press Ctrl+C. This copies the information to the Clipboard.
2. Switch to Excel and select the cell where you want the link to appear.
3. Choose Paste As Hyperlink from the Edit menu or, if you are using Excel 2007, click the down-arrow under the Paste option on the Home tab of the ribbon and then chooe Paste As Hyperlink.

The information appears as a hyperlink, and if you click on it, you are taken directly to the spot in the original document from which it was copied.