Excel HYPERLINK Formula

This Excel Tutorial demonstrates how to use the Excel HYPERLINK Function in Excel to create a clickable link, with formula examples.

HYPERLINK Function Description:

The HYPERLINK Function Creates a clickable link. The link may refer to a webpage, external document, or a cell within the active workbook.

Formula Examples:

hyperlink function examples

ExampleFormulaResult
Website=HYPERLINK(C5,D5)Excel Boot Camp
Reference in Excel=HYPERLINK(C6,D6)Hyperlink
Desktop=HYPERLINK(C7,D7)Program Files

Syntax and Arguments:

The Syntax for the HYPERLINK Formula is:

Function Arguments ( Inputs ):

link_location – The file path, web address, or link address. Example: “www.excelbootcamp.com”

friendly_name – The link name to display. Example: Excel Boot Camp

Additional Notes

Use the HYPERLINK Function to create a hyperlink to a cell within the workbook, an external file, or a webpage. Clicking the link will “goto” to reference. Depending on the type of hyperlink, this may open a web browser, another file, or simply jump to the referenced cell in the activate workbook.

To select a cell containing a hyperlink, without opening it, select the cell using the arrow keys.

If you use the hyperlinks that open webpages in Excel you may want to change the text that identifies the link(called Anchor text in webspeak).

Usually you can just type a URL in a cell and it automatically converts to a Hyperlink. This works fine for linking to Domains, however when I link to individual pages the link looks long and ugly. Fortunately Excel provides a way to choose the text that displays. Excel calls it friendly_name.

To control the text that displays for a Hyperlinked cell, enter your link as follows:

Syntax

=HYPERLINK(link_location,[friendly_name])

Example

=HYPERLINK(“https://www.automateexcel.com/excel”,”Automate Excel Home Page”)

Return to the List of all Functions in Excel

How to use the HYPERLINK Function in Excel:

To use the AND Excel Worksheet Function, type the following into a cell:
=AND(
After entering it in the cell, notice how the AND formula inputs appear below the cell:
hyperlink formula syntax
You will need to enter these inputs into the function. The function inputs are covered in more detail in the next section. However, if you ever need more help with the function, after typing “=HYPERLINK(” into a cell, without leaving the cell, use the shortcut CTRL + A (A for Arguments) to open the “Insert Function Dialog Box” for detailed instructions:
how to use the hyperlink function in excel

For more information about the HYPERLINK Formula visit the
Microsoft Website.

ADS GO HERE

Posted in