The fastest way to add a hyperlink in Excel

To add a hyperlink in Excel, right-click the cell where you want the link, select Link from the menu, type or paste the web address in the URL field, and click OK. The cell text turns blue and underlined. When someone clicks it, Excel opens that link in their browser.

You can also use the keyboard shortcut Ctrl+K (Windows) or Cmd+K (Mac) to open the link dialog without right-clicking. This works whether you have text already in the cell or not.

If you want the link to display different text than the actual URL — for example, showing "Click here" instead of "https://example.com" — type your display text in the cell first, then add the hyperlink. Excel keeps the visible text but stores the URL behind it.

Key Takeaways

  • Right-click a cell and select Link, or press Ctrl+K (Windows) or Cmd+K (Mac), to open the hyperlink dialog.
  • Paste the full web address (including https://) into the URL field to avoid Excel treating it as plain text.
  • The cell displays blue underlined text by default, but you can change the text that shows while keeping the same link destination.
  • Links to other sheets within the same workbook use the sheet name in the address, such as Sheet2!A1.
  • Remove a hyperlink by right-clicking it and selecting Remove Link, which keeps the text but deletes the clickable destination.

Linking to websites and email addresses

For web links, always include the full protocol at the start — type https://www.example.com, not just www.example.com. If you skip the https://, Excel may treat it as text instead of a clickable link. The same rule applies whether you are linking to a homepage, a specific page, or a file hosted online.

To create a link that opens an email, use the format mailto:name@example.com in the URL field. When someone clicks this link, their default email program opens with that address already filled in as the recipient. You can add a subject line by typing mailto:name@example.com?subject=Your%20Subject%20Here, replacing spaces with %20.

Test your links before sharing the spreadsheet. Click each one to confirm it opens the correct page or email program. Broken links — those pointing to pages that no longer exist — will fail silently or show an error depending on your browser.

Linking to other sheets and cells within the same workbook

To link to a different sheet in the same Excel file, use the sheet name followed by an exclamation mark and the cell reference. For example, type Sheet2!A1 in the URL field to link to cell A1 on Sheet2. If your sheet name contains spaces, wrap it in single quotes: 'Sales Data'!B5.

You can also link to a named range instead of typing cell references. If you have created a named range called "Q4_Results", type Q4_Results in the URL field. This is useful when you want the link to point to a meaningful location rather than a specific cell address that might change later.

When someone clicks an internal link, Excel jumps to that sheet and cell but does not open a new window. The link stays within the same file, so this approach works well for navigation in large workbooks with many sheets.

Changing link text and removing links

The text that appears in a cell can be different from the link destination. If you want to change what the cell displays, right-click the cell with the hyperlink and select Edit Link. Change the text in the "Display text" field while leaving the URL unchanged. For example, you could display "Company Website" while the actual link points to https://example.com/about.

To remove a hyperlink entirely, right-click the cell and select Remove Link. This deletes the clickable destination but keeps the text in the cell. The text no longer appears blue and underlined, and clicking it does nothing.

If you want to edit the destination URL itself, right-click and select Edit Link again. Change the address in the URL field and click OK. This is faster than deleting and recreating the link if you only need to update where it points.

Formatting hyperlinks and avoiding common mistakes

By default, hyperlinks appear in blue with an underline, following Excel's standard formatting. If you want to change the color or remove the underline, select the cell and use the font color and underline buttons in the toolbar. However, keeping the standard blue formatting helps readers recognize the link immediately.

A common mistake is pasting a URL directly into a cell and expecting Excel to recognize it automatically. Excel sometimes converts URLs to links on its own, but not always — especially if the URL is missing https:// or if you paste it into a cell that already contains other text. Use the Link dialog to be certain.

Another issue occurs when you copy a cell with a hyperlink. The link copies along with it, but it points to the same destination in both places. If you want the copied link to adjust to a new location (like a relative reference), you need to recreate the link in the new cell rather than copying it.

Using the Insert menu as an alternative

Instead of right-clicking, you can add a hyperlink through the menu bar. Click Insert at the top, then select Link from the dropdown. This opens the same dialog as right-clicking or using the keyboard shortcut. The menu approach takes more steps but works the same way.

In Excel for Mac, the menu path is Insert > Link. In Excel for Windows, it is also Insert > Link. Both versions show the same dialog box with fields for URL, display text, and other options.

Frequently Asked Questions

Can I add a hyperlink to a file on my computer instead of a website?

Yes. In the URL field, type the full file path starting with the drive letter, such as C:\Users\YourName\Documents\Report.pdf on Windows or /Users/YourName/Documents/Report.pdf on Mac. When someone clicks the link, Excel opens that file. This works best when the file location is stable and the spreadsheet stays on the same computer or network.

What happens if I share a spreadsheet with hyperlinks with someone else?

Links to websites work for anyone who has internet access. Links to files on your computer may break if the other person does not have the file in the same location. Internal links (to other sheets in the same workbook) always work as long as the sheet names have not changed.

Can I add a hyperlink to an image or shape instead of text?

Yes. Right-click the image or shape and select Link. The same dialog appears, and you can enter a URL or internal reference. The image or shape becomes clickable, though it no longer shows the typical blue underline that indicates a link.

How do I prevent Excel from automatically converting URLs into hyperlinks?

Excel's AutoCorrect feature converts many URLs to links automatically. To turn this off, go to File > Options > Proofing > AutoCorrect Options and uncheck "Internet and network paths with hyperlinks" under the AutoFormat tab. After that, you will need to add hyperlinks manually using the Link dialog.

Can I add a hyperlink to a cell that already has a formula?

No. A cell can contain either a formula or a hyperlink, but not both. If you need a clickable link and a calculated value, create the formula in one cell and the hyperlink in an adjacent cell, or use a formula that generates a hyperlink using the HYPERLINK function instead of the manual Link dialog.