The fastest way 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 web address in their browser.

If you want the link text to say something different from the URL itself — for example, showing "Q3 Report" instead of "https://example.com/reports/q3" — type your display text in the cell first, then right-click and add the link. Excel keeps your text visible while hiding the actual URL behind it.

This method works the same way in Excel Online, Excel on Mac, and Excel on Windows. The right-click menu is the most direct route for single links or small batches.

Key Takeaways

  • Right-click any cell, select Link, paste the URL, and click OK to create a hyperlink in seconds.
  • Use Ctrl+K (Windows) or Cmd+K (Mac) as a keyboard shortcut instead of right-clicking if you prefer speed.
  • Link to external websites, other sheets within the same workbook, or specific cells by their address.
  • Remove a hyperlink by right-clicking it and selecting Remove Link — the cell text stays behind.
  • Test every link before sharing the spreadsheet, because broken URLs show as dead links to other people.

Using the keyboard shortcut for faster linking

On Windows, press Ctrl+K while the cell is selected. On Mac, press Cmd+K. Either way, the Link dialog box opens when ready. Type or paste your URL, add display text if needed, and press Enter.

This shortcut is faster than right-clicking if you are adding multiple links in one session. You stay on the keyboard instead of switching between keyboard and mouse. After you press Enter, Excel moves to the next cell, so you can chain several links without stopping.

Linking to other sheets or specific cells within your workbook

You can link to a different sheet in the same Excel file instead of an external website. Right-click the cell, select Link, then choose Place in This Document instead of typing a URL. A panel appears showing all your sheet names.

Click the sheet you want, then either link to the whole sheet or type a cell address like A1 to jump to that specific cell. This is useful when your spreadsheet has multiple sheets and you want readers to navigate between them without scrolling or searching manually.

For example, you might have a summary sheet with links to detailed data on Sheet2, Sheet3, and Sheet4. When someone clicks a link on the summary, Excel takes them directly to the relevant section.

What happens when you click a hyperlink in Excel

Clicking a hyperlink in Excel opens it in your default web browser — the same browser you use when you click links anywhere else on your computer. The spreadsheet stays open in the background. You can close the browser tab or window and return to Excel without losing your place.

If the URL is broken or the website is down, your browser shows an error page instead of the content. This is why testing links before you share a spreadsheet matters: you want to catch dead links before other people encounter them.

In Excel Online (the web version), links work the same way. In shared workbooks where multiple people have access, every person sees the same links and can click them independently.

Removing or editing a hyperlink

To remove a hyperlink but keep the text in the cell, right-click the link and select Remove Link. The cell text stays exactly as it was — only the link disappears. The text no longer turns blue or underlines.

To change where a link points, right-click it and select Edit Link (or Link on some versions). The dialog box opens with the current URL. Change it to the new address and click OK. The cell text does not change, only the destination.

If you need to change the display text itself — what the cell shows — you can edit the cell normally by double-clicking it or pressing F2, then typing new text. The link stays attached to whatever text you leave behind.

Common mistakes and how to avoid them

The most common mistake is forgetting to include https:// or http:// at the start of the URL. If you type only "example.com", Excel may not recognize it as a web address. Always include the full protocol at the beginning.

Another mistake is sharing a spreadsheet with links that point to files on your personal computer — like "C:\Users\YourName\Documents\Report.pdf". Other people cannot access files on your hard drive, so those links break when ready. If you need to link to a file, upload it to a shared location like OneDrive or Google Drive first, then link to the public URL.

Testing links before you send the spreadsheet catches both problems. Open each link in your browser and confirm it loads. If you are sharing the file with others, test the links from a different computer or account to make sure they work for someone outside your network.

Linking to email addresses

You can create a link that opens someone's email program instead of a website. Right-click the cell, select Link, then type mailto: followed by the email address — for example, mailto:contact@example.com. When someone clicks the link, their default email program opens a new message addressed to that person.

This is useful in contact lists or when you want readers to send feedback without having to copy and paste an address. The email program opens on their computer, so they can add their message and send it directly.

Frequently Asked Questions

Can I make a hyperlink open in a new tab instead of the same window?

Excel does not have a built-in option to force links to open in a new tab. When someone clicks a link, it opens in their default browser behavior — usually a new tab if they use Chrome or Firefox, or a new window if they use Internet Explorer. You cannot control this from within Excel itself.

What if the hyperlink text is too long to fit in the cell?

Make the column wider by dragging the column border, or enable text wrapping in the cell format. Right-click the cell, select Format Cells, go to the Alignment tab, and check Wrap text. The cell expands to show all the text across multiple lines.

Can I copy a hyperlink from one cell to another?

Yes. Click the cell with the link, press Ctrl+C (or Cmd+C on Mac) to copy, then click the destination cell and press Ctrl+V (or Cmd+V). The link copies with all its settings intact. The display text and the URL both transfer to the new cell.

Do hyperlinks work the same way in Excel on Mac as on Windows?

Yes, with one difference: use Cmd+K instead of Ctrl+K for the keyboard shortcut. Everything else — right-click menus, link dialogs, removing links, and how they behave when clicked — works identically on both platforms.

What happens to hyperlinks when I save the file as a PDF?

Hyperlinks stay active in the PDF. When someone opens the PDF and clicks a link, it opens in their browser just like it would in Excel. This is useful if you want to share a spreadsheet as a PDF while keeping the links functional.