What does it do?
Creates a shortcut to a webpage, spreadsheet reference, or a file in the hard drive
Formula breakdown:
=HYPERLINK(link_location, [friendly_name])
What it means:
=HYPERLINK(link to a webpage / spreadsheet reference / hard drive file, [display name])
Imagine you can create links in your Excel spreadsheet that either links to: website urls, other parts in your workbook, or even to a file in your hard drive.
The HYPERLINK Formula in Excel lets you dynamically create these!
I explain how you can do this below:
STEP 1: We need to enter the HYPERLINKÂ function in a blank cell:
=HYPERLINK(
STEP 2:Â The HYPERLINKÂ arguments:
link_location
What is the exact link location?
Select the cell containing the link location:
=HYPERLINK(C9,
friendly_name
What will be the display name of the link?
Select the cell containing the display name. This gives your link a more presentable name:
=HYPERLINK(C9, D9)
Apply the same formula to the rest of the cells by dragging the lower right corner downwards.
You now have your hyperlinks all ready to go!
How to Use the HYPERLINK Formula in Excel
