Can’t Hyperlink in Excel? Create and Fix Links

Errors & fixes · Updated November 18, 2026

Yes, you can add clickable hyperlinks in Excel to websites, files, email addresses, and places in a workbook. In Microsoft 365 for Windows, select a cell and press Ctrl+K, enter the destination, and choose OK; if a link will not insert or open, the cause is usually a setting, protection, or destination issue.

What a hyperlink in Excel can do

A hyperlink connects a cell or an object, such as a shape, to a destination. That destination might be a web page, a file, an email address, or another location in the current workbook. For example, a project tracker can have a link labeled “Open project folder,” while a contents sheet can link directly to a section on another worksheet.

A hyperlink is different from a formula that retrieves information from another workbook. A link is something a user follows to navigate to a destination; a workbook reference is part of a calculation. Confusing the two can make troubleshooting harder: a cell that displays an external-workbook formula is not necessarily a clickable link.

Create a hyperlink with the Insert Link command

For a regular link in Excel for Microsoft 365 on Windows:

  1. Select the cell where the link should appear. To link existing text in a cell, select that cell; Excel uses its contents as the displayed text unless you change it.
  2. Press Ctrl+K, or open the Insert tab and choose Link. You can also right-click a cell and choose Link when that command is available in the context menu.
  3. Choose the kind of destination in the link dialog. Depending on the destination, enter a web address, select a file, provide an email address, or choose a place in the current workbook.
  4. Check the displayed text and destination, then choose OK. Click the link or use the follow-link shortcut described below to confirm that it goes where intended.

On a Mac, use Command+K to open the link dialog; the Insert tab also provides a Link command. Excel for the web has an Insert > Link command as well, though the dialog and available file locations can differ from the desktop app. If the workbook is stored in OneDrive or SharePoint, links to shared cloud files are often more useful to collaborators than links to a file path on one person’s computer.

Make a link with the HYPERLINK function

You can also create a link with Excel’s HYPERLINK function, which is useful when a destination or link label comes from other cells. With web addresses in A2 and friendly labels in B2, enter this in C2 and fill it down:

=HYPERLINK(A2,B2)

For example, if A2 contains https://example.com and B2 contains Company website, C2 displays “Company website” as a clickable link to that address. The first argument supplies the destination; the optional second argument supplies the text shown in the cell. If you omit the second argument, Excel displays the destination itself. The function can create links to web locations, files, and workbook locations, but it does not grant access to a destination that the user otherwise cannot reach.

When copying formulas down a list, check that each row points to the intended address and label. A blank or incorrect address cell can produce a blank-looking or unhelpful link, and a formula can be overwritten if someone pastes values over it. Use the Insert Link dialog instead when you want a one-off link and do not need the destination to be generated from worksheet data.

Link to another sheet or cell

To navigate within the same workbook, select the cell, open the link dialog, and choose the option for a place in the current document. Select the worksheet and, where offered, specify a cell reference. A table of contents sheet might link to A1 on a worksheet named “Quarterly Sales,” letting readers jump to that sheet without searching through tabs.

Internal links are especially useful in long workbooks, but check them after renaming or reorganizing sheets. Excel generally adjusts workbook references when a sheet is renamed, but a copied link, a manually typed destination, or a link to a removed location may not take the reader where expected. Test links after restructuring a workbook and use clear labels that identify the destination rather than generic text such as “click here.”

Why Excel may not create a link automatically

Excel can automatically turn some typed web addresses and network paths into hyperlinks, but that behavior depends on an AutoCorrect setting. On Windows, open File > Options > Proofing > AutoCorrect Options, select the AutoFormat As You Type tab, and check whether Internet and network paths with hyperlinks is selected. If it is turned off, typing an address may leave it as ordinary text. You can still create a link manually with Ctrl+K.

Automatic detection is not guaranteed for every string that resembles an address. Excel may wait until you press Space or Enter, and a pasted address may not be converted in the same way as one typed into a cell. Formatting can also affect what appears: a cell formatted as Text may preserve an entry as text rather than treating it as a link. The exact behavior can vary by app version and settings, so manual insertion is the reliable option when the automatic conversion does not happen.

Common reasons a hyperlink will not work

If you cannot add, edit, or follow a link, check the problem that matches what you see:

  • The link command is unavailable or changes are blocked: The worksheet or workbook may be protected, or you may have view-only access. Ask the workbook owner for permission or for the relevant protection to be removed before editing.
  • The address is plain text: Use Insert > Link or Ctrl+K to add the destination manually. Check the AutoCorrect setting if you want Excel to convert typed addresses automatically.
  • A click edits the cell instead of opening the link: Excel may be in cell-edit mode, or the click may be selecting the cell. Press Esc to leave editing mode, then follow the link. On Windows, Excel commonly requires Ctrl+click when the “Use Ctrl+Click to follow hyperlink” option is enabled under File > Options > Advanced, in the Editing options area.
  • The link opens an error or the wrong place: Reopen the link with Ctrl+K or right-click and choose Edit Link, then check for a typo, an outdated address, or a file path that is unavailable on this computer.
  • A file link works only for you: It may point to a local path such as a folder on your computer. A colleague will not necessarily have that same path or permission. Store the file in a shared location and use a link that the intended readers can access.
  • The displayed text is not clickable: Check whether the cell contains a HYPERLINK formula or merely text that looks like one. A formula entered as text, such as in a cell formatted as Text, will not behave like a calculated hyperlink until the entry is corrected and recalculated.

For a link that opens a web page in the wrong browser or does not open the browser at all, check the computer’s default app for web links as well as the destination address. Excel hands the destination to the operating system; it does not control every browser or account sign-in issue.

Edit, remove, or change a hyperlink

To change a destination or its displayed text, right-click the linked cell and choose Edit Link, or select it and press Ctrl+K. Update the address or display text in the dialog and confirm. On a Mac, use Command+K for the link dialog; labels in context menus can vary slightly by app version.

To remove a link while keeping the cell’s text, right-click the cell and choose Remove Hyperlink. The text remains as ordinary cell content. If you want to remove the text too, delete the cell contents separately. This distinction matters in a directory or index: removing the link does not automatically erase the label.

Linking to files, shared workbooks, and email

A file hyperlink is only useful if its intended readers can reach the file. A path such as one inside a user’s Downloads folder will usually be specific to that person’s computer. For shared work, place documents in a shared network location or cloud storage and use an address that collaborators are authorized to open. Moving or renaming the target file can break a link, so keep shared folders organized and test important destinations after changes.

You can also link to an email address, which usually starts an email in the reader’s configured mail application. That does not send a message automatically: the person still reviews and sends it. For a workbook shared externally, consider whether the destination exposes private folder names, internal systems, or information that recipients should not see.

Hyperlinks, accessibility, and safe use

Use meaningful link text. A label such as “Download the current price list” tells readers more than a bare URL or “here,” and it is easier to understand when navigating a worksheet with assistive technology. Avoid relying on color alone to signal that a cell is a link; include clear wording and, where appropriate, a consistent layout.

Treat unexpected links with the same caution as links in email. Check the destination before opening it, especially in a workbook received from an unfamiliar source. A hyperlink can lead to a deceptive page or an unwanted download. Excel may display a warning for some external destinations, and a warning should not be dismissed automatically. Hyperlinks are navigation, not proof that a destination is trustworthy.

Frequently Asked Questions

Why can’t I click a hyperlink in Excel?
Excel may require Ctrl+click on Windows if “Use Ctrl+Click to follow hyperlink” is enabled. Press Esc if you are editing the cell, then try Ctrl+click. Also confirm that the cell contains an actual link and that its destination is available.

How do I turn a URL into a hyperlink in Excel?
Select the cell and press Ctrl+K on Windows, enter or confirm the URL, and choose OK. On a Mac, press Command+K. To have typed addresses convert automatically, check the AutoFormat As You Type hyperlink option.

Can I link to another worksheet in the same Excel file?
Yes. Open the link dialog and choose a place in the current document, then select the worksheet and cell. You can use this to build a navigation or contents sheet for a large workbook.

Why does my Excel link work on my computer but not someone else’s?
The link may point to a local file or a location the other person cannot access. Use a shared location and confirm that the recipient has permission to open the file; a hyperlink cannot provide access by itself.

How do I remove a hyperlink but keep the words?
Right-click the linked cell and choose Remove Hyperlink. Excel removes the clickable destination while leaving the displayed text in the cell.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.