How to use the Hyperlink function in Excel
There are many ways to create Hyperlink links, but if you want to create more identical or similar links, the best and fastest way that Software Tips introduces you is to use the Hyperlink function.
How to use the Hyperlink function in Excel
Functional structure
= HYPERLINK (link_location, [friendly_name])
Inside:
- Link_location (required argument) is the link to the website or file that is already opened. The link_location can be a reference to a cell containing a link or a string of characters enclosed in quotes containing a path to a file stored on the hard drive, a UNC path on the server, a line. UNC leads on the internet or intranet.
- Friendly_name (optional argument) is the link text (also the jump text or anchor text) displayed in the cell. If you omit this, the link_location argument will be displayed as the link text as well.
Note:
- If the hyperlink does not exist or is broken, the Hyperlink function will display an error when you click the cell.
- If the function returns an error value of VALUE! Or N / A appears in a cell, most likely the problem is with the friendly_name argument in your Hyperlink function.
Example of using Hyperlink function
Links to other sheets
To link to another sheet, use the formula = HYPERLINK ("# sheet name! A1", "the reference name you want to put").
You have the following example:
To create a link to the " car rental " worksheet in the same file, type the formula = HYPERLINK ("# 'car rental'! A1", "A") and get the result:
When you click on the letter A, Excel automatically moves to cell A1 of the "car rental price" page.
Note: to get to the position of any cell in the worksheet, you just need to replace the position of the cell with A1 in the above formula.
Link to another spreadsheet
To create a link to another workbook, specify the full path to the target worksheet in the following format: " D: Vidugiá xe xe.xlsx" by right-clicking the file you need and selecting Properties .
In a cell without the Hyperlink function, type the formula:
= HYPERLINK ("D: Vidugiá car rental.xlsx", "B"). The result is:
Link to a website
To create a link to a website, enter the link for that site into the link_location argument.
Link to email
To create an email link to someone, you need an email address in the following format: mailto: email_address in the link_location argument.
Hyperlink function does not work
The main reason that the Hyperlink function doesn't work is because the path no longer exists or is broken in the link_location argument. When this error occurs, you should check the destination address of the link, make sure that the link location is provided in the correct format.
So, surely you already know how to create hyperlinks in Excel. Good luck!
You should read it
- How to create suggestions for Hyperlink in Excel
- This is a simple way to find and delete Hyperlink in Excel
- Instructions on how to create Hyperlink in Excel
- Basic Excel functions that anyone must know
- How to create Hyperlink to link in Excel
- How to use Hlookup function on Excel
- How to use the SUM function to calculate totals in Excel
- Create Hyperlink in Excel
May be interested
- Create Hyperlink in Excelcreate hyperlinks in excel - the following article guides you to create hyperlinks to websites, to other sheets in the same excel file, links to newly created excel files and links to email addresses.
- How to use the LEN function in Excelthe len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
- How to use COUNTIF function on Excelthe countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
- How to use the MOD function and QUOTIENT function in Excelinjury in excel has many ways of doing it, can be used manually or using the calculation function.
- 8 little-known Excel functions that can save you a lot of workeven seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
- How to use MID functions to get strings in Excelmid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
- How to use Excel's VALUE functionexcel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
- How to delete links in Excel, delete hyperlinks in Excelwhat if you want to disable hyperlink links in excel? there are many ways for us to quickly find and delete links in excel.
- How to use the WRAPROWS function in Excelhaving trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.