spot_img

Hyperlinks

 

Existing File or Web Page | Place in This Document | 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.

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:Reportssales2020.docx” and the second argument with “Open Report”.

spot_img
Previous articleHow to use GETPIVOTDATA in Excel
Next articleHow to Lock Cells in Excel