Hyperlink with the HYPERLINK function
As you know, Excel is a powerful spreadsheet program with lots of built-in functions to help you work efficiently with data and numbers. Excel has a function for inserting hyperlinks, too.
You can insert hyperlinks by using the HYPERLINK function in Excel.
The syntax of the HYPERLINK function is:
The HYPERLINK function has the following arguments:
- link_location refers to a place in a document where the link points to. This could be a URL, a cell reference, or another spreadsheet or word file. This is required.
- friendly_name is the display text in the cell. It is displayed in blue and underlined. This is optional, but we recommend using it.
It makes for easier reading. If the friendly_name is omitted, the cell displays the link_location as the jump text.
The HYPERLINK function can be used in two important cases.
The first case is when you want to hyperlink to specific cells in external spreadsheets. The second case is when you want to hyperlink to a cell reference rather than using the URL.
Hyperlink function to cells in external spreadsheets
Let’s use this formula.
=HYPERLINK(“[name of the spreadsheet]cell reference”, “friendly name”)
For example, I want to link to a spreadsheet called “MIN-MAX-FUNCTIONS-Spreadsheeto-Project-File” and I want the link to point to cell B6 on the first sheet. Here’s how I’d do that:
Instead of displaying the link location, a friendly name is displayed.
When you click the friendly name “Welcome!”, it will direct you to the cell reference of the Excel file.
You just need to make sure to know the file location, the brackets, and the quotation marks are in the right place as well😊
Hyperlink function to cell reference
The second case in which you might want to use the HYPERLINK function is when the link could change.
In this case, you can use a cell reference instead of writing in the URL. This way, whenever the URL (or file path) in the cell changes, the link will automatically update.
For our example, the cell address of our URL is A12. So let’s type,
For the friendly name, we can type anything, like “Website”.
Even though the link in the cell address might change, the hyperlinked cell will automatically update.