Ravindra BagaleCourses & study guides Track your progress

Excel HYPERLINK Function

By · Last updated:

Chala mitrano — today we learn HYPERLINK. Read Why → What → How, then try the practice list.

Version note. Classic Excel (old and new). Works widely — still missing as a dedicated lesson page on this site before this preview.
Fictional sample data for learning. example.com mail and paths are for learning patterns only.

Purpose

Create a clickable link to a web page, file path, or place in the workbook.

Return value

A hyperlink displayed with friendly name text.

Syntax

HYPERLINK(link_location, [friendly_name])

Arguments

ArgumentRequired?Description
link_locationRequiredURL, or "Sheet1!A1" style place, or file path.
friendly_nameOptionalText to show instead of the raw URL.

Version

Classic Excel (old and new). Works widely — still missing as a dedicated lesson page on this site before this preview.

How to use — Why → What → How

Why: Menus hide links. Formulas can build hundreds of links from a table of URLs.

What: HYPERLINK shows clickable text that opens the target.

How — numbered steps:

  1. Web: =HYPERLINK("https://ravindrabagale.com/excel/","Excel hub").
  2. Internal: =HYPERLINK("#Sheet2!A1","Go to Sheet2").
  3. Build from columns: =HYPERLINK(A2, B2).
  4. Warn users before clicking unknown links.
  5. Use for learning-path style tables.

Ravindra Bagale's Tip

Never auto-click strange links in class files from the internet.

Ravindra Bagale's Tip

Friendly name should describe the destination, not “click here” alone.

Worked examples

1) Link to Excel hub

Site nav helper.

Formula: =HYPERLINK("https://ravindrabagale.com/excel/","Excel course hub")

Result: Clickable hub link

What it means: Opens the course hub.

2) From table columns

A2 URL, B2 title.

Formula: =HYPERLINK(A2,B2)

Result: Titled links

What it means: Bulk links.

3) Jump inside workbook

TOC.

Formula: =HYPERLINK("#Practice!A1","Open Practice sheet")

Result: Internal jump

What it means: Hash sheet place.

4) Mailto

Support.

Formula: =HYPERLINK("mailto:info@example.com","Email support")

Result: Mail client

What it means: Optional pattern.

5) Learning path chapter

Ch 4.

Formula: =HYPERLINK("https://ravindrabagale.com/excel/ch04-lookup-functions/","Ch 4 Lookups")

Result: Chapter link

What it means: Pairs with learning-path page.

Common errors

#REF! / broken jumps: Bad sheet place.
Security prompts: Excel warns on external links — expected.

Practice tasks (10+)

  1. Task 1. Link to https://ravindrabagale.com/excel/.
    Hint: try on a tiny range first
  2. Task 2. Build 5 links from a URL column.
    Hint: try on a tiny range first
  3. Task 3. Internal link to a Practice sheet.
    Hint: try on a tiny range first
  4. Task 4. Rewrite friendly names clearly.
    Hint: try on a tiny range first
  5. Task 5. Explain phishing caution.
    Hint: try on a tiny range first
  6. Task 6. HYPERLINK + IF to show “Missing URL” when blank.
    Hint: try on a tiny range first
  7. Task 7. Compare to Insert → Link.
    Hint: try on a tiny range first
  8. Task 8. Add links for learning-path chapters.
    Hint: try on a tiny range first
  9. Task 9. Test in Excel Online vs desktop.
    Hint: try on a tiny range first
  10. Task 10. Bonus: HYPERLINK to a filtered location.
    Hint: try on a tiny range first

Quick quiz

Q1. Friendly name is optional but recommended.
Q2. HYPERLINK exists only in Excel 365.
Q3. You can link inside the same workbook.
Q4. Users should trust every link blindly.

Answers: Q1=True, Q2=False, Q3=True, Q4=False

Related: LAMBDA · LET · GROUPBY · Function hub · Learning path