You can use the HYPERLINK function to create a link that opens a document that is stored on a network server, an intranet, or the Internet. To display helpful information when you rest the pointer on the link, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK. In the Text to display box, type the text that you want to use to represent the link. In the list under Defined Names, click the name that represents the cells that you want to link to, and then click OK.

In the Or select a place in this document box, under Cell Reference, click the worksheet that you want to link to, type the cell reference in the Type in the cell reference box, and then click OK. To link to a location in another workbook, click Existing File or Web Page, locate and select the workbook that you want to link to, and then click Bookmark. To link to a location in your current workbook, click Place in This Document. On a worksheet of the source workbook, click the cell where you want to create a link. Note: Names can't contain spaces and must begin with a letter. If you want to create a link to a specific location in the file or on the web page, click Bookmark, and then double-click the bookmark that you want. To locate a web page, click Browse the Web, open the web page that you want to link to, and then switch back to Excel without closing your browser. To enter the name and location of a known file or web page that you want to link to, type that information in the Address box. To select a file that you recently used, click Recent Files, and then click the file that you want to link to. To select a web page, click Browsed Pages and then click the web page that you want to link to. You can change the current folder by selecting a different folder in the Look in list. To select a file, click Current Folder, and then click the file that you want to link to. Under Link to, click Existing File or Web Page. You can also right-click the cell or object and then click Link on the shortcut menu, or you can press Ctrl+K. On the Insert tab, in the Links group, click Link.

You can also select an object, such as a picture or an element in a chart, that you want to use to represent the link. On a worksheet, click the cell where you want to create a link.

How to use microsoft excel workbook