Excel - Microsoft Excel hyperlink Function

Description

The Excel Hyperlink function creates a hyperlink to a document in a supplied location. 

The syntax of the function is : 

HYPERLINK( link_location, friendly_name ) 

where the arguments are as follows: 

The address supplied for the link_location argument can be an absolute reference or a relative reference. The difference between these two reference types is shown in the table below. 

Hyperlink Function Examples

Excel Hyperlinks are an excellent way of organising your data. This is shown in the spreadsheet the right, which collates details of sales invoices, and uses the Excel Hyperlink function to create links to individual invoices. The spreadsheet below shows the functions used to create the hyperlinks : 

As the current spreadsheet is located in the directory C:\Invoices, the Excel hyperlink functions in cells B2 and B3, create links to the invoice files Invoice_B001.pdf and Invoice_B002.pdf, which are both located in the directory C:\Invoices. The result is shown in the spreadsheet below : 

The hyperlinks in cells B2 and B3 allow you to open up the files Invoice_B001.pdf and Invoice_B002.pdf simply by clicking on the cells B2 and B3. 

Note that, in this example, cell B2 uses an absolute reference, while B3 uses a relative reference. As the current spreadsheet is located in the directory C:\Invoices, the relative reference in cell B3 links to the file C:\Invoices\Invoice B002.pdf.