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 Formula in Excel


STEP 2: The HYPERLINK arguments:


What is the exact link location?

Select the cell containing the link location:


HYPERLINK Formula in Excel


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 Formula in Excel


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!

HYPERLINK Formula in Excel


How to Use the HYPERLINK Formula in Excel





If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn