When working in Excel, there is often a need to link to other items such as files, folders, workbooks, Web pages, etc. Excel 2010 makes it easy to link to the necessary data using hyperlinks. You can use hyperlinks in your Excel workbook to link to existing file or Web page. You can link from Excel to a specific point in a document. Excel also allows you to link to an email address similar to a mailto link in Outlook.
In this article, I’ll show you how to use hyperlinks in Excel 2010 to link to your important data.
First of all, to create a hyperlink, right click the cell in which you want to create the hyperlink and click Hyperlink from the menu.
The Insert Hyperlink window appears.
Your next steps will vary depending on what you want to link to.
Link to an Existing File or Web Page
To link to an existing file or Web page, select Existing File or Web Page from the Link to: list. Within the right pane, select the file or Web page that you want to link to. Next, do one of the following:
- To select a file, click Current Folder, 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.
- To select a file that you recently used, click Recent Files, and then click the file that you want to link to.
- 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 locate a Web page, click Browse the Web, open the Web page that you want to link to, and then switch back to Office Excel without closing your browser.
Within the Text to display field, type in the text you want to display within the cell instead of the path. Click OK.