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:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the HYPERLINK function in a blank cell:

=HYPERLINK(

HYPERLINK Formula in Excel

 

STEP 2: The HYPERLINK arguments:

link_location

What is the exact link location?

Select the cell containing the link location:

=HYPERLINK(C9,

HYPERLINK Formula in Excel

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)

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

HELPFUL RESOURCE:

 

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials