Hyperlink to a specific location on web page in Excel

To create a hyperlink to a specific location on a Web page, make sure the Web page has a bookmark at that location.

1. In Microsoft Excel, right-click the text or graphic you want to represent the hyperlink, and then click Hyperlink on the shortcut menu.
2. Under Link to on the left side of the dialog box, click Existing file or Web page.
3. Do one of the following:
• To select a Web page from the current folder, click Current Folder and then click the Web page you want to link to.
• To select the Web page from a list of browsed pages, click Browsed Pages and then click the Web page you want to link to.
• To select a Web page from a list of files you have recently used, click Recent Files and then click the Web page you want to link to.
• If you know the name and location of the Web page you want to link to, you can type that information in the Address box.
• To select the Web page by opening your browser and searching for the page, click Browse the Web , open the Web page you want to link to, and then switch back to Excel without closing your browser.
4. Click Bookmark, and then double-click the bookmark you want.
5. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip, type the text you want in the ScreenTip text box, and then click OK.