Enable Auto Hyperlink Excel

by

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

You would need to correct the hyperlink address to the updated file name so that the file becomes detectable. Follow the steps below to edit the address. Step 1: Copy the address of the new file from the file's explorer. Step 2: Head to Excel. Step 3: Right-click on the hyperlink, and click 'Edit hyperlink' in the menu. Apr 07, 2021 In the right pane, right-click DisableHyperlinkWarning, and then click Modify. In the Edit DWORD Value dialog box, click Decimal, and then type 1 or 0 under Value data. A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message. Exit Registry Editor. Oct 23, 2009 To turn the hyperlink option off in Excel 2007: Click the Office Button, then click Excel Options. Click the Proofing category, and click the AutoCorrect Options button. Select the AutoFormat As You Type tab. Remove the check mark from Internet and network paths with hyperlinks. Click OK, twice, to close the dialog boxes.

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.

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

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

Result:

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.

The 'Insert Hyperlink' dialog box appears.

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

Enable auto hyperlink excel shortcut

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

Result:

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.

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

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.

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

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

Result:

Auto

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.

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.

Result:

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.

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