Friendly_name (optional) is the link text (aka jump text or anchor text) to be displayed in a cell.If the specified link path does not exist or is broken, a Hyperlink formula will throw an error when you click the cell. Link_location can be supplied as a reference to a cell containing the link or a text string enclosed in quotation marks that contains a path to a file stored on a local drive, UNC path on a server, or URL on the Internet or intranet. Link_location (required) is the path to the web-page or file to be opened.The syntax of the HYPERLINK function is as follows: In Excel Online, the HYPERLINK function can only be used for web addresses (URLs). The function is available in all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, and Excel 2000. Word, PowerPoint or other document stored on your hard disk drive, local network or online.A specific place such as a cell or named range in an Excel file (in the existing sheet or in another worksheet or workbook).By using a Hyperlink formula, you can link to the following items: The HYPERLINK function in Excel is used to create a reference (shortcut) that directs the user to the specified location in the same document or opens another document or web-page. Excel HYPERLINK not working - reasons and solutionsĮxcel HYPERLINK function - syntax and basic uses.
If you plan to insert many identical or similar links, the fastest way is to use a Hyperlink formula, which makes it easier to create, copy and edit hyperlinks in Excel. To link to another worksheet or a specific location in another Excel file, you can use the Hyperlink context menu or Ctrl + K shortcut. To link to a certain web page, you can simply type its URL in a cell, hit Enter, and Microsoft Excel will automatically convert the entry into a clickable hyperlink. There are many ways to create a hyperlink in Excel.
This tutorial explains the basics of the Excel HYPERLINK function and provides a few tips and formula examples to use it most efficiently.