To insert a hyperlink to a different sheet in the same workbook, supply the target sheet name preceded by a pound sign (#), and followed by the exclamation point and target cell reference, like this: The Excel HYPERLINK function enables you to insert clickable hyperlinks of a few different types depending on what value you supply to the link_location argument.
HOW TO REMOVE HYPERLINK IN EXCEL LIBRE HOW TO
How to link to sheets, files, web-pages and other items We will also discuss a more complex formula where Excel HYPERLINK is used in a combination with a few other functions to accomplish a non-trivial challenging task. Moving from theory to practice, let's see how you can use the HYPERLINK function to open various documents directly from your worksheets. How to use HYPERLINK in Excel - formula examples More formula examples demonstrating other uses of the Excel HYPERLINK function follow below. The result may look something similar to this: If omitted, link_location is displayed as the link text.įriendly_name can be supplied as a numeric value, text string enclosed in quotation marks, name, or reference to a cell that contains the link text.Ĭlicking a cell with a Hyperlink formula opens the file or web-page specified in the link_location argument.īelow, you can see the simplest example of an Excel Hyperlink formula, where A2 contains friendly_name and B2 contains link_location:
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.How to edit multiple Hyperlink formulas at a time.Vlookup and insert a hyperlink to the first match.How to use HYPERLINK in Excel - formula examples.
This tutorial explains the basics of the Excel HYPERLINK function and provides a few tips and formula examples to use it most efficiently.
0 kommentar(er)
