How To Create Hyperlink In Excel 2007

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Pasting a Hyperlink.

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:

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 click Paste Special. Excel displays the Paste Special dialog box.
Choose Hyperlink from the list of options. (See Figure 1.)

Figure 1. The Paste Special dialog box with the Hyperlink option highlighted.

Click OK

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 (9668) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Pasting a Hyperlink.

Author Bio

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...

MORE FROM ALLEN

Format Painter Shortcut

Need a way to copy formatting using the keyboard? Word has a great one, and it doesn't involve the Format Painter or the ...

Discover More

WordTips Ribbon 2020 Archive (Table of Contents)

WordTips is a weekly newsletter that provides tips on how to best use Microsoft's word processing software. At ...

Discover More

Saving Search and Replace Information in a Macro

You may want to save a user's existing Find and Replace settings before changing them in your macro. This tip examines ...

Discover More

More ExcelTips (ribbon)

Drop-Down List of Hyperlinks

Creating a drop-down list with Excel's data validation feature can be a nice touch for a worksheet. What if you want the ...

Discover More

Extracting URLs from Hyperlinked Images

When copying information from the Internet to an Excel workbook, you may want to get rid of graphics but keep any ...

Discover More

Hyperlink Doesn't Match Cell Contents

When you add a hyperlink to a worksheet, over time and after doing a bunch of editing, what you see in the cell can get ...

Discover More