To create a hyperlink in Excel, execute the following steps.
1. On the Insert tab, in the Links group, click Hyperlink.
The 'Insert Hyperlink' dialog box appears.
Existing File or Web Page
To create a link to an existing file or web page, execute the following steps.
1a. To create a link to an existing Excel file, select a file (use the Look in drop-down list, if necessary).
1b. To create a link 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 link to a place in this document, execute the following steps.
1. Click 'Place in This Document' under Link to.
2. 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 link, click ScreenTip..