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

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Pasting a Hyperlink