![]() =HYPERLINK("Sheet1!Source_data","Source data") "Sheet!Name"įor instance, to insert a link to a range named "Source_data" stored on Sheet1 in Book1, use this formula: If you are making a hyperlink to a worksheet-level name, include the full path to the target name: For more information, please see Absolute and relative hyperlinks in Excel. When you move the files, the relative hyperlink will continue working as long as the relative path to the target workbook remains unchanged. =HYPERLINK("Source data\Book3.xlsx", "Book3") If you plan to move your workbooks to another location soon, you can create a relative link like this: "Sheet!Cell"įor example, to add a hyperlink titled "Book3" that opens Sheet2 in Book3 stored in the Source data folder on drive D, use this formula: To land on a specific sheet and even in a specific cell, use this format: =HYPERLINK("D:\Source data\Book3.xlsx", "Book3") To create a hyperlink to another workbook, you need to specify the full path to the target workbook in the following format: For example, to insert a hyperlink that will take you to cell A1 in the same worksheet, use a formula similar to this: In the same way, you can make a hyperlink to another cell in the same sheet. =HYPERLINK("#'Price list'!A1", "Price list") If the worksheet name includes spaces or non-alphabetical characters, it must be enclosed in single quotation marks, like this: ![]() The above formula creates a hyperlink with the jump text "Sheet2" that opens Sheet2 in the current workbook. 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 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: 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.It does not store any personal data.HYPERLINK(link_location, ) The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. ![]() The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". ![]() These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |