FormulaCraft

HYPERLINK

HYPERLINK creates a clickable link within a cell, combining a URL or file path with optional friendly display text. It is useful for building navigation links, linking to external references, or creating dynamic links that change based on cell values. The first argument is the link destination and the second optional argument is the label shown in the cell.

Excel
=HYPERLINK("https://formulacraft.app","FormulaCraft")
Google Sheets
=HYPERLINK("https://formulacraft.app","FormulaCraft")

Verified example

Computed by a real spreadsheet engine on the sample data below.

SiteURL
FormulaCrafthttps://formulacraft.app
Googlehttps://google.com
GitHubhttps://github.com

=HYPERLINK("https://formulacraft.app","FormulaCraft")FormulaCraft

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1"https://formulacraft.app" is the URL or file path the link will navigate to when clicked.
  2. 2"FormulaCraft" is the friendly display text shown in the cell instead of the raw URL.
  3. 3If you omit the second argument, the raw URL itself is displayed as the link label.

Need a version for your data?

Try: “Create a clickable link in a cell that goes to a website

Related

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: