• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Formulas / Excel HYPERLINK Function

Excel HYPERLINK Function

The Excel HYPERLINK function creates hyperlinks to to other sheets, webpages or files such as PDF’s on your Excel spreadsheet.

The real power behind this function is that it can be used to create dynamic hyperlinks that are dependent upon cell values or results from formulas.

We can create conditional hyperlinks by nesting them within an IF function, or create hyperlinks that can find the address to link to themselves by embedding lookup or text functions within them. This helps us to create automated and error resistant spreadsheets.

The HYPERLINK Function

The Excel HYPERLINK function is written as;

=HYPERLINK(link_location, [friendly_name])

Link Location: This is the cell, file or webpage that you want to link to. A # symbol can be used when referencing a cell within the active workbook.

Friendly Name: This is the text used as the hyperlink text that users will click on. This information is optional, and if omitted the text used by the links destination will be used.

Excel HYPERLINK Function Example

If you are creating a static hyperlink to another file you should use the Hyperlink button on the Insert tab. The HYPERLINK function is here for impressive dynamic links.

In this example, we want to create a hyperlink in column C of our table of contents. The user can then click the hyperlink to jump to the sheet of the country entered in column B.

Table of contents using the HYPERLINK function in Excel

The formula below uses the CONCATENATE function to join together the hash symbol, the countries name from cell B3, and A1 preceded by the exclamation mark. By referencing cell B3, when copied, this function would take the user to the correct sheet.

=HYPERLINK(CONCATENATE("#",B3,"!A1"),"Go to Page")

Watch the Video

Related Posts:

  • Live currency exchange rate in Excel thumbnail
    LIVE Currency Exchange Rate in Excel
  • Copy a formula down in Excel
    How to Copy a Formula Down in Excel
  • Case sensitive XLOOKUP feature
    Case Sensitive Lookup with XLOOKUP in Excel
  • Compare dates in Excel feature
    How to Compare Dates in Excel

Reader Interactions

Comments

  1. asim says

    22 October 2013 at 1:08 pm

    Please send me comlpete links “Using the Hyperlink Function in Excel”
    thanking you
    asim

    Reply
  2. Ranjit says

    13 January 2016 at 9:59 pm

    Hi , Great video on Dynamic Hyper links. I was wondering if you could help me with a different issue. I wish to create a hyperlink in excell to point to a word document, which is a simple task, but I wish to make it dynamic, so it points to a specific Heading or title of my choice.
    Hope to hear back form you

    Reply
  3. Mounir HAFIANE says

    2 January 2017 at 5:20 pm

    100000000 thanks for you… you are an angel… because of you I preserved a lot of time and effort… thank you my friend

    Reply
    • computergaga says

      2 January 2017 at 6:58 pm

      Your welcome

      Reply
  4. Paul Danville says

    4 September 2017 at 4:07 am

    Very cool thanks

    Reply
  5. Qahtan Al-zaidi says

    6 January 2018 at 4:39 pm

    Thanks a lot for your efforts and time…I really appreciate it

    Reply
    • computergaga says

      6 January 2018 at 5:40 pm

      You’re welcome Qahtan, thank you.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·