Create Hyperlinks in Excel Cells

Here's a simple trick. Some times I have data results in Excel, if combined with other URL data, it would take me to a specific record. For example, if I extracted Contact Record IDs from and combined it with the URL prefix, I could view the record that corresponds to the ID.

There are a few different approaches, but it all ends up using the same function: Hyperlink. Hyperlink takes two parameters: link_location and friendly_name (optional). Here are some examples:
  • =HYPERLINK("" & B2)
  • =HYPERLINK("" & B2,"Joe Smith")
The link location, in addition to being a URL could be a drive path (c:\foo\), a UNC path (\\Server1\folder1\), or even a "mailto:" (=HYPERLINK("mailto:" & H2)).


Popular posts from this blog

Digital Signatures in PDF Do Not Print

Referencing the value of a cell, not its formula

CorelDRAW X4 Crash on Startup