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:

HYPERLINK Formula in Excel | MyExcelOnline

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.

HYPERLINK Formula in Excel | MyExcelOnline

You now have your hyperlinks all ready to go!

HYPERLINK Formula in Excel

 

How to Use the HYPERLINK Formula in Excel

 

HELPFUL RESOURCE:

 

HYPERLINK Formula in Excel | MyExcelOnline

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn