Pasting a Hyperlink

Summary: When you copy information from one workbook to another, you may want to link that information as a hyperlink. You can quickly achieve this goal by using the steps presented in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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.
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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2465) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.

Check out Top Fifteen Tips for Financing Christmas today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Pasting a Hyperlink