MS Excel 2003 Training 101 - Hyperlink

Create a hyperlink to a new file

1. Right-click the cell or graphic you want to represent the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), and then click Hyperlink on the shortcut menu.
2. Under Link to on the left side of the dialog box, click Create new document.
3. Type a name for the new file in the Name of new document box.
4. To specify a location other than the one shown under Full Path, type the new location in the Name of new document box or click Change and then select the location you want. Click OK.
5. Under When to edit, click an option to specify whether to open the new file for editing now or later.
6. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. Click OK.

Create a hyperlink to an existing file or Web page

1. Right-click the text or graphic you want to represent the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), 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 file from the current folder, click Current Folder and then click the file 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 file from a list of files you have recently used, click Recent Files and then click the file you want to link to.
If you know the name and location of the file or 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 Microsoft Excel without closing your browser.
4. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. Click OK.

Create a hyperlink to a specific location on a Web page

To create a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) to a specific location on a Web page, make sure the Web page has a bookmark (bookmark: A location or selection of text in a file that you name for reference purposes. Bookmarks identify a location within your file that you can later refer or link to.) 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

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.

Create a hyperlink to a specific location in a workbook

To link to a location in the current workbook or another workbook, you can either define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the destination (destination: General term for the name of the element you go to from a hyperlink.) cells or use a cell reference.
1. To use a name, name the destination cells in the destination workbook.
How?

1. Select the cell, range of cells, or nonadjacent selections (nonadjacent selection: A selection of two or more cells or ranges that don't touch each other. When plotting nonadjacent selections in a chart, make sure that the combined selections form a rectangular shape.) that you want to name.
2. Click the Name box at the left end of the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.)
3. Type the name for the cells.
4. Press ENTER.

 Note   You cannot name a cell while you are changing the contents of the cell.

2. In the source (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) workbook, right-click the text or graphic you want to represent the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), and then click Hyperlink on the shortcut menu.
3. Do one of the following:
To link to a location in your current workbook, click Place in this document under Link to.
To link to a location in another workbook, click Existing file or Web page under Link to.
4. If you chose Existing file or Web page, locate and select the workbook you want to link to, and then click the Bookmark button.
5. Do one of the following:
In the list under Cell Reference, click the sheet you want to link to, and then type the cell reference in the Type in the cell reference box. Click OK.
In the list under Defined Names, click the name that represents the cells you want to link to. Click OK.
6. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. Click OK.
Create a customized hyperlink by using a worksheet function
Creates a shortcut or jump that opens a document stored on a network server, an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.), or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file stored at link_location.