1. Home
  2. Guides
  3. How to Add a Hyperlink in Excel

Guide

How to Add a Hyperlink in Excel

Excel doesn't use HTML — it has its own two ways to build a clickable link: the Insert Hyperlink dialog for one-off links, and the HYPERLINK() formula for links that need to be built from other cell data or copied down a column.

Written by HyperlinkCreator Editorial Team • Last updated August 15, 2026 • 6 min read

Method 1: Insert Hyperlink dialog

  1. Select the cell

    Click the cell you want to turn into a link.

  2. Open Insert > Link (or press Ctrl+K)

    Excel opens the Insert Hyperlink dialog.

  3. Choose the destination and confirm

    Paste a web address, pick a location in the current workbook, or enter an email address, then select OK. The cell becomes clickable immediately.

This is the fastest option for a single link, and it's what most people reach for first. For links that depend on other data in the sheet — or that you need to repeat down a whole column — the formula below is more reliable.

Method 2: The HYPERLINK() formula

=HYPERLINK(link_location, [friendly_name])
ArgumentRequired?What it does
link_locationYesThe destination — a URL, a cell reference, a sheet name, or a mailto: address. Limited to 255 characters.
friendly_nameNoThe text the cell displays. If omitted, the cell shows the raw link_location instead.

Formula examples

=HYPERLINK("https://example.com", "Visit Example")

=HYPERLINK("mailto:hello@example.com", "Email us")

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

=HYPERLINK(B2, "Open this row's link")

Because link_location can reference another cell, HYPERLINK() is the better choice whenever you're generating links from a list of URLs already in the sheet — drag the formula down the column and every row updates automatically.

Building many links at once? If your URLs don't live in Excel yet, it's often faster to generate them first with the bulk hyperlink generator and paste the finished list straight into the sheet.

Fixing & removing hyperlinks

A pasted link isn't clickable

Excel normally auto-converts a plain URL into a link the moment you press Enter or Tab. If that isn't happening, the cell may already be formatted as text — select it, use Insert > Link (Ctrl+K), and confirm the address manually to force it.

Removing a hyperlink

Right-click the cell and choose Remove Hyperlink to drop the link but keep the visible text. Choose Clear Hyperlinks instead if you also want to strip the blue, underlined formatting that comes with it.

Reference: Microsoft Support — HYPERLINK function.

Need a link outside Excel too?

Build the matching HTML or Markdown version with the same URL — free, private, copy and paste ready.

Open the Hyperlink Creator

FAQ

Excel hyperlink questions

What is the Excel HYPERLINK function?

HYPERLINK(link_location, [friendly_name]) is a formula that builds a clickable link inside a cell. link_location is the destination — a webpage, a mailto: address, or a location in the workbook — and the optional friendly_name is the text the cell displays instead of the raw address.

How do I make multiple hyperlinks in Excel at once?

Drag-fill a HYPERLINK() formula down a column of URLs, or generate the links outside Excel first with the bulk hyperlink generator and paste the results in.

Why isn't my Excel hyperlink clickable?

URLs pasted as plain text usually auto-convert to clickable links on their own. If autoformatting is off, or the cell was formatted as text before you typed the URL, select the cell, go to Insert > Link (or press Ctrl+K), and confirm the address manually.

How do I remove a hyperlink in Excel?

Right-click the cell and choose "Remove Hyperlink" — this removes the link but keeps the text. To strip both the link and its blue/underlined formatting, right-click and choose "Clear Hyperlinks" instead, or select the cell and clear formatting separately.