Creates a shortcut or jump that opens a document stored on a network server, an
intranetA network within an organization that uses Internet technologies (such as the HTTP or FTP protocols). You can use an intranet to move between objects, documents, pages, and other destinations using hyperlinks., or the Internet. When you click the cell that contains the
HYPERLINK function, Excel
opens the file stored at
link_location.
Syntax
HYPERLINK(link_location,friendly_name)
Argument | Description | Remarks |
|---|
link_location | The path and file name to the document to be opened as text. The argument
link_location can refer to a place in a document — such as a specific cell or named range in a Excel
sheet or workbook, or to a bookmark in a Word
document. The path can be to a file stored on a hard disk or a Uniform Resource Locator (URL) path on the Internet or an intranet. | -
The argument
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 | The jump text or numeric value that is displayed in the cell. | -
The argument
friendly_name is displayed in blue and is underlined.
-
If
friendly_name is omitted, the cell displays the
link_location as the jump text.
-
The argument
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.
|
To select a cell that contains
HYPERLINK, click a cell next to the cell, and then use an arrow key to move to the cell.
Example
The following examples link to fictitious documents and locations. The examples may be easier to understand if you copy them to a blank sheet, and then follow any data requirements outlined in the example descriptions.
| |
| Formula | Description (Result) | | =HYPERLINK("http://example.microsoft.com/report/budget report.xls","Click for report") | Opens a sheet 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]Annual!F10",D1) | Creates a hyperlink to cell F10 on the sheet 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 sheet that contains the hyperlink displays the contents of cell D1 as the jump text. | | =HYPERLINK("[http://example.microsoft.com/report/budget report.xls]First Quarter!DeptTotal","Click to see First Quarter Department Total") | Creates a hyperlink to the range named DeptTotal on the sheet 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 sheet that contains the hyperlink displays the text "Click to see First Quarter Department Total." | | =HYPERLINK("[http://example.microsoft.com/Annual Report.doc]QrtlyProfits","Quarterly Profit Report") | Creates a hyperlink to the bookmark named QrtlyProfits in a Word
document named Annual Report.doc located at example.microsoft.com. To create a hyperlink to a specific location in a Word
document, you must use a bookmark to define the location you want to jump to in the document. | | =HYPERLINK("Macintosh HD:Budget Reports:First Quarter","Click here") | 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("\\FINANCE\Statements\1stqtr.xls",D5) | In Excel
for Windows, 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("[C:\My Documents\Mybook.xls]Totals") | In Excel
for Windows, creates a hyperlink to the area named Totals in another (external) workbook, Mybook.xls. | |
=HYPERLINK("D:\FINANCE\1stqtr.xls",H10) | In Excel
for Windows, opens the file 1stqtr.xls that is stored in a directory named Finance on drive D, and displays the numeric value stored in cell H10. |
|
