Wauvel

Excel like a finance pro.

← The library

Lookup function

HYPERLINK

Creates a clickable link to a file, web page, or cell.

CommonDifficulty 1050 · CapableUsage rank #137 of 520
Practice · 3 questions →

When to use it

Creates a clickable link with display text: web pages, files, email, or a spot in the workbook.

The shape of it

Syntax
=HYPERLINK(link_location, [friendly_name])

Worked examples

  • Web link

    =HYPERLINK("https://example.com","Site") → Site

    Shows Site; clicking opens the page.

  • Jump within the workbook

    =HYPERLINK("#Sheet2!A1","Go to summary") → Go to summary

    A # prefix links inside the workbook.

  • Email link

    =HYPERLINK("mailto:"&A2,"Email") → Email

    Opens a new message to the address in A2.

Worth knowing

  • Build a table of links to every sheet with sheet names in a column.
  • Cell-relative jumps: "#"&CELL("address",target).
  • Format the cell to look like a link; HYPERLINK does not style it.

Where it goes wrong

  • Nothing happens on click when the link text is malformed or the file has moved.
  • Some corporate policies block file links.

Related

VLOOKUPXLOOKUPINDEXMATCHROWHLOOKUP

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.