The HYPERLINK formula is displayed in cell C5 of the following image. Close the parentheses and press the “Enter” key.Enter the jump text enclosed within double quotation marks.This serves as the “link_location” argument. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. Prefix the hash (#), followed by the name of the worksheet, the exclamation mark (!), and the cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties.Open the HYPERLINK function by typing =HYPERLINK in Excel.To switch to a different worksheet within the same workbook via a hyperlink, follow the listed steps: Example #2–Switch Between the Worksheets Using a Hyperlink The address mentioned in the “mailto” link is considered to belong to the intended recipient. Note: “Mailto” links are used in HTML to send emails from the default mail client of the user. Notice that the “friendly_name” has been omitted for the hyperlinks of these cells as well. The outputs of the HYPERLINK formulas are displayed in these cells. Likewise, the HYPERLINK formula has been applied to cells C3 and C4. This field contains the email address of one or more recipients. The given email address will be automatically entered in the “To” field. Since the “friendly_name” argument has been omitted in the HYPERLINK formula, the “link_location” is used as the jump text.Ĭlicking the created hyperlink will open the “compose” page of the default email account. Result of the HYPERLINK formula: The prefix along with the entire address (mailto: ) will be displayed as a hyperlink. You can download this HYPERLINK Function Excel Template here – HYPERLINK Function Excel Template The HYPERLINK formula in excel can return errors in the following situations: If the latter is omitted, the former is considered as the jump text. The argument “link_location” is required while “friendly_name” is optional. The blue color of the jump text indicates that it is clickable. It can be supplied as a text string enclosed within double quotation marks, numeric value or reference to a cell containing the on-screen name. It is also called the jump text, link text or anchor text. Friendly_name: This is the on-screen name of the hyperlink.The intended location can be a cell, named range (in any workbook), bookmark or file in Word, web page on the intranet or Internet, file on Excel or PowerPoint, etc. It can be supplied as a text string enclosed within double quotation marks or a reference to a cell that contains this text string. Link_location: This is the path to the intended location.The HYPERLINK function of Excel accepts the following arguments: The formula of the HYPERLINK function of Excel is shown in the following image. The Key Points Governing Hyperlink Formula in Excelįormula of the HYPERLINK Function of Excel.How to Make a Picture or Cell of Excel a Clickable Hyperlink?.Example #3–Open a File Using a Hyperlink.Example #2–Switch Between the Worksheets Using a Hyperlink.Example #1–Send an Email Using a Hyperlink.Formula of the HYPERLINK Function of Excel.The HYPERLINK function is categorized under the Lookup & Reference functions of Excel. This source is usually related to the current data of the worksheet. read more is to provide the end-user with an additional source of information. Then, in the field for an address, type the hyperlink's URL. Apart from text, a picture can also be turned into a clickable hyperlink.įor example, the formula =HYPERLINK(“”,”WSM”) creates a hyperlink named “WSM.” When clicked, this hyperlink opens the website “The purpose of creating a hyperlink in Excel Hyperlink In Excel To insert a hyperlink, right-click on the cell, click on hyperlink, and then choose the last option, which will open a wizard box to insert a hyperlink. Once a hyperlink is created, this name is underlined and displayed in blue. Every link is given a desired on-screen name. The HYPERLINK function of Excel helps create a link (or hyperlink), which when clicked, takes the user to the intended location.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |