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:
- Select the information to be copied and press Ctrl+C. This copies the information to the Clipboard.
- Switch to Excel and select the cell where you want the link to appear.
Click the down-arrow under the Paste option on the Home tab of the ribbon and then choose 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.