Adding a link in Excel takes three steps: select the cell, open the Insert Link dialog, and paste or type the web address

To add a link to a cell in Excel, click the cell where you want the link to appear. Then press Ctrl+K on Windows or Cmd+K on Mac. A dialog box titled "Insert Hyperlink" will open. Type or paste the web address (for example, https://www.example.com) into the "Address" field, then click OK. The cell now contains a clickable link.

You can also link to a different sheet within the same workbook, to a specific cell location, or to an email address. The same keyboard shortcut works for all of these. The link appears as blue underlined text by default, and anyone who opens the file can click it to follow the link or send an email.

Key Takeaways

  • Press Ctrl+K (Windows) or Cmd+K (Mac) after selecting a cell to open the Insert Hyperlink dialog.
  • Paste the full web address including https:// into the Address field to link to a website.
  • You can link to another sheet in the same workbook by choosing "Place in This Document" and selecting the sheet and cell.
  • Links appear as blue underlined text and remain clickable when the file is shared or opened by others.
  • Right-click a link and select "Remove Hyperlink" to delete it without removing the cell text.

Linking to a website or web page

Select the cell where you want the link. Press Ctrl+K (or Cmd+K on Mac). In the "Address" field, type or paste the full web address, starting with https:// or http://. If you want the link text to display something different from the address itself, type that text in the "Display Text" field. Click OK.

For example, you might have the text "Company Website" in a cell but want it to link to https://www.example.com. Type "Company Website" in the Display Text field and the full URL in the Address field. When someone clicks the link, it opens the website, not the text.

Linking to another sheet or cell in the same workbook

Select the cell and press Ctrl+K. In the Insert Hyperlink dialog, click "Place in This Document" on the left side (or the equivalent option in your version). A list of sheets in your workbook will appear. Click the sheet you want to link to, then type the cell reference (like A1 or B5) in the "Cell Reference" field if you want to link to a specific location.

This is useful when you have a large workbook with multiple sheets and want to create a navigation link. For instance, you might have a summary sheet with links to detailed data on other sheets. When someone clicks the link, Excel jumps to that sheet and cell.

Creating an email link

Select the cell and press Ctrl+K. In the Insert Hyperlink dialog, click "E-mail Address" on the left side. Type the email address in the "E-mail Address" field. You can also add a subject line in the "Subject" field if you want the email to open with a pre-filled subject.

When someone clicks an email link, it opens their default email program with the recipient address already filled in. If you added a subject, that appears in the subject line too. This is helpful for feedback forms or contact links within a shared spreadsheet.

Editing or removing a link

To change a link, right-click the cell containing it and select "Edit Hyperlink". The Insert Hyperlink dialog opens again. Make your changes and click OK. To remove the link entirely while keeping the text, right-click and select "Remove Hyperlink". The text stays in the cell, but it is no longer clickable.

You can also click a cell with a link and press Ctrl+K to edit it. This opens the same dialog where you can change the address, display text, or any other setting.

What happens when you share a file with links

Links remain active when you share an Excel file with others. If you link to a website, anyone who opens the file can click the link and visit that page. If you link to another sheet in the same workbook, the link works for anyone who has the file open. External links (to files or websites outside the workbook) may prompt a security warning when someone opens the file, depending on their Excel settings.

If you link to a file on your computer, that link will only work for others if they have the same file in the same location. For shared files, web links are more reliable than links to local files.

Common issues and how to fix them

If a link does not work after you create it, check that the web address is complete and correct, including the https:// or http:// at the start. If you are linking to another sheet, make sure the sheet name is spelled exactly as it appears in your workbook tabs. If the link opens but shows an error page, the website address may have changed or the page may no longer exist.

If a link to another file is not working, verify that the file still exists in the location you specified. If you moved the file, the link breaks. For links that should work for multiple people, use web addresses instead of file paths whenever possible.

Frequently Asked Questions

Can I make a link open in a new window or tab?

Excel does not have a built-in option to force links to open in a new tab. When someone clicks a link in Excel, it opens in their default browser behavior. However, users can right-click a link and choose to open it in a new tab manually.

What if I want to link to a specific part of a web page?

If the website uses anchor links (also called bookmarks), you can add the anchor to the end of the URL. For example, https://www.example.com#section-name. Not all websites support this, so test the link first to make sure it jumps to the right spot.

Can I link to a PDF file?

Yes. Use the same process as linking to a website, but type the full path to the PDF file. If it is on the web, use the full URL (https://example.com/document.pdf). If it is on your computer, use the file path (C:\Users\YourName\Documents\file.pdf), though this only works for others if they have the file in the same location.

How do I change the color of a link?

Links use your workbook's theme colors by default. To change link color for the entire workbook, go to the Page Layout or Design tab, click the Colors dropdown, and choose a different theme. To change a single link's appearance, you can format the cell text color, though this may make it less obvious that it is a link.

What is the difference between a hyperlink and a regular link?

In Excel, these terms mean the same thing. A hyperlink is a clickable link in a cell that takes you to a website, email address, or another location. Excel calls the feature "Insert Hyperlink," but people often just say "link."