![]() The jump text or numeric value that is displayed in the cell. If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.įriendly_name Optional. Link_location can be a text string enclosed in quotation marks or a reference to a cell that contains the link as a text string. Note Excel for the web the HYPERLINK function is valid for web addresses (URLs) only. ![]() The path can also be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet. The path can be to a file that is stored on a hard disk drive. ![]() 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 and file name to the document to be opened. The HYPERLINK function syntax has the following arguments: When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified. The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. This article describes the formula syntax and usage of the HYPERLINK function in Microsoft Excel.
0 Comments
Leave a Reply. |