Hyperlinks

 

Existing File or Web Page  |  Place in This Document  |  Edit Hyperlink Style  |  Hyperlink Function

Use the 'Insert Hyperlink' dialog box in Excel to create a hyperlink to an existing file, a web page or a place in this document. You can also use the HYPERLINK function.

Existing File or Web Page

To create a hyperlink to an existing file or web page, execute the following steps.

1. Select cell A1.

2. On the Insert tab, in the Links group, click Link.

Click link

The 'Insert Hyperlink' dialog box appears.

3a. To create a hyperlink to an existing file, select a file (use the Look in drop-down list, if necessary).

Existing File

3b. To create a hyperlink to a web page, type the Text to display, the Address, and click OK.

Web Page

Result:

Go to Webpage

Note: if you want to change the text that appears when you hover over the link, click ScreenTip.

Place in This Document

To create a hyperlink to a place in this document, execute the following steps.

1. Select cell A2.

2. On the Insert tab, in the Links group, click Link.

Click link

The 'Insert Hyperlink' dialog box appears.

3. Click 'Place in This Document' under Link to.

4. Type the Text to display, the cell reference, and click OK.

Place in This Document

Result:

Go to Place in This Document

Note: if you want to change the text that appears when you hover over the hyperlink, click ScreenTip.

Edit Hyperlink Style

You can quickly change the style of all hyperlinks in a workbook.

1. First, create at least one hyperlink (and click on it).

2. After completing step 1, you'll find two new styles on the Home tab in the Styles group: Hyperlink and Followed Hyperlink (the style of a clicked link).

Hyperlink Styles in Excel

For example, to prevent hyperlinks from changing color in Excel, execute the following steps.

3. Right click on Followed Hyperlink and click Modify.

Modify Followed Hyperlink Style

4. Click Format.

Format Followed Hyperlink Style

5. On the Font tab, change the color to #0563C1 (same as Hyperlink).

Change Color of Clicked Hyperlinks

6. Click OK twice.

7. Click a hyperlink (the color won't change).

Prevent Hyperlinks from Changing Color

Hyperlink Function

You can also use the HYPERLINK function in Excel to create hyperlinks. The HYPERLINK function has two arguments.

HYPERLINK function in Excel

Note: instead of creating a hyperlink to a web page, create a hyperlink to an existing file. For example, replace the first argument with "C:\Reports\sales2020.docx" and the second argument with "Open Report".