HYPERLINK
Formulas / HYPERLINKCreate a clickable link.
=HYPERLINK(link_location, [friendly_name])
- link_location - required path and filename to the document to be opened
- friendly_name - [OPTIONAL] text or numeric value that is displayed in the cell as the user types it in
Examples
=HYPERLINK("#Sheet2!A1","Sheet2")creates a hyperlink to a worksheet named "Sheet2" and the cell A1 on that worksheet. This is useful for navigating between sheets in the same workbook.=HYPERLINK("www.example.com","Example Website")creates a hyperlink to a website. This is useful for quickly navigating to a specific website from Sourcetable.=HYPERLINK("#'Sheet 2'!A1","Sheet 2")will generate an invalid error because there is a space in the sheet name. To avoid this, use an underscore or remove the space when naming the sheet.=HYPERLINK("http://www.example.com","Example Website")creates a hyperlink to a website using the http protocol. This is useful for quickly navigating to a specific website from Sourcetable.=HYPERLINK("https://www.example.com","Example Website")creates a hyperlink to a website using the https protocol. This is useful for quickly navigating to a secure website from Sourcetable.=HYPERLINK("file:///C:/example.xlsx","Example File")creates a hyperlink to a file on the user's computer.
Summary
The HYPERLINK function creates a shortcut that when clicked will jump to a different location in the current workbook, or open a document stored on a network server, intranet, or the Internet.
- The HYPERLINK function can create links to worksheet locations, pages on the internet, or to files on network servers, and can also create email links.
- The link_location argument can be a cell reference, a named range, or a text string in quotation marks.
- The friendly_name argument is optional and may be the text displayed in a cell as a link or the text displayed with the link.
- The link_location argument may also be a reference to a cell that contains the link path.
Frequently Asked Questions
What is the HYPERLINK function?
The HYPERLINK function creates a link to a cell reference, to a file stored on a local drive or on a server, or to a website or file on the internet.
What kind of links can the HYPERLINK function create?
The HYPERLINK function can create links to workbook locations, pages on the internet, or to files on network servers. It can also create email links.
What types of paths can the link_location and friendly_name arguments accept?
- Cell references
- Named ranges
- Paths to files stored on local drives
- Paths to files on a server using Universal Naming Convention
- Paths to files on the internet using Uniform Resource Locator
