Create a hyperlink

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

ShowCreate a hyperlink to a new file

  1. Right-click the cell or graphic you want to represent the hyperlink (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.), 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.

ShowCreate a hyperlink to an existing file or Web page

  1. Right-click the text or graphic you want to represent the hyperlink (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.), 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 Button image, 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.

ShowCreate a hyperlink to a specific location on a Web page

To create a hyperlink (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.) 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 Button image, 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.

ShowCreate 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.

ShowHow?

  1. 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: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.), and then click Hyperlink on the shortcut menu.
  2. 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.
  1. If you chose Existing file or Web page, locate and select the workbook you want to link to, and then click the Bookmark button.
  2. 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.
  1. 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.

ShowCreate 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.

Syntax

HYPERLINK(link_location,friendly_name)

Link_location     is the path and file name to the document to be opened as text. Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.)) path on the Internet or an intranet.

  • Link_location can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
  • If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.

Friendly_name     is the jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text.

  • Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value.
  • If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.

Remark

To select a cell that contains HYPERLINK, click the cell and hold the mouse button until the cursor becomes a cross Excel selection cursor, then release the mouse button.

Examples

The following example opens a worksheet named Budget Report.xls that is stored on the Internet at the location named example.microsoft.com/report and displays the text "Click for report":

=HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click for report")

The following example creates a hyperlink to cell F10 on the worksheet named Annual in the workbook Budget Report.xls, which is stored on the Internet at the location named example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays the contents of cell D1 as the jump text:

=HYPERLINK("[http://example.microsoft.com/report/budget report.xls]Annual!F10", D1)

The following example creates a hyperlink to the range named DeptTotal on the worksheet named First Quarter in the workbook Budget Report.xls, which is stored on the Internet at the location named example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays the text "Click to see First Quarter Department Total":

=HYPERLINK("[http://example.microsoft.com/report/budget report.xls]First Quarter!DeptTotal", "Click to see First Quarter Department Total")

To create a hyperlink to a specific location in a Microsoft Word document, you must use a bookmark to define the location you want to jump to in the document. The following example creates a hyperlink to the bookmark named QrtlyProfits in the document named Annual Report.doc located at example.microsoft.com:

=HYPERLINK("[http://example.microsoft.com/Annual Report.doc]QrtlyProfits", "Quarterly Profit Report")

In Excel for Windows, the following example displays the contents of cell D5 as the jump text in the cell and opens the file named 1stqtr.xls, which is stored on the server named FINANCE in the Statements share. This example uses a UNC path:

=HYPERLINK("\\FINANCE\Statements\1stqtr.xls", D5)

The following example opens the file 1stqtr.xls in Excel for Windows that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10:

=HYPERLINK("D:\FINANCE\1stqtr.xls", H10)

In Excel for Windows, the following example creates a hyperlink to the area named Totals in another (external) workbook, Mybook.xls:

=HYPERLINK("[C:\My Documents\Mybook.xls]Totals")

In Microsoft Excel for the Macintosh, the following example displays "Click here" in the cell and opens the file named First Quarter that is stored in a folder named Budget Reports on the hard drive named Macintosh HD:

=HYPERLINK("Macintosh HD:Budget Reports:First Quarter", "Click here")

You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56.

=HYPERLINK("[Budget]June!E56", E56)

To jump to a different sheet in the same workbook, change the name of the sheet in the link. In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September."

ShowCreate a hyperlink to an e-mail address

When you click a hyperlink (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.) to an e-mail address, your e-mail program automatically starts and creates an e-mail message with the correct address in the To box, provided you have an e-mail program installed.

  1. 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 E-mail address.
  3. In the E-mail address box, type the e-mail address you want.
  4. In the Subject box, type the subject of the e-mail message.

Note that some Web browsers (Web browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Windows Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.) and e-mail programs might not recognize the subject line.

  1. 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.

ShowTip

You can also create a hyperlink to an e-mail address in a cell by typing the address directly in the cell. For example, type someone@example.com, and the hyperlink is created automatically.

 
 
Applies to:
Excel 2003