The Two Ways to Add a Link in Excel

You can create a hyperlink in Excel in two ways: using the keyboard shortcut Ctrl+K (or Cmd+K on Mac), or right-clicking and selecting "Link" from the menu. Both methods open the same dialog box where you type the web address or file path you want to link to. The keyboard shortcut is faster once you know it exists.

A hyperlink in Excel works the same way it does on a website — click it and you go somewhere else. That somewhere can be a web address, another file on your computer, another sheet in the same workbook, or even a specific cell. The cell containing the link shows the text in blue and underlined by default, so anyone opening your spreadsheet knows it is clickable.

Key Takeaways

  • Press Ctrl+K (Windows) or Cmd+K (Mac) after selecting the cell where you want the link, then type the web address or file path in the dialog box that appears.
  • The text that shows in the cell can be different from the actual link destination — you can make a cell say "Click here for data" while linking to a specific file or webpage.
  • You can link to another sheet in the same workbook by selecting "Place in This Document" in the link dialog and choosing the sheet name and cell.
  • Right-click a hyperlink and select "Remove Hyperlink" to delete it without deleting the text in the cell.

Creating a Link to a Website

Select the cell where you want the link to appear. Type the text you want readers to see — for example, "Company Website" or "read Report". Then press Ctrl+K (Windows) or Cmd+K (Mac). A dialog box titled "Insert Hyperlink" opens.

In the "Address" field at the bottom of the dialog, type the full web address: https://www.example.com. Include the https:// part — Excel will not recognize it as a web link without it. Click OK. The text in your cell now appears in blue and underlined, and clicking it opens that website in your browser.

If you want the link text to be different from what you typed in the cell, you can change it. In the "Text to display" field near the top of the dialog, type whatever you want to show instead. For example, you could type "Annual Report 2024" in the cell, but have the link go to a different file entirely.

Linking to Another File on Your Computer

Select the cell and press Ctrl+K. In the Insert Hyperlink dialog, click "Browse" next to the Address field. A file browser window opens. Navigate to the file you want to link to — it can be another Excel file, a PDF, a Word document, or any other file type. Click the file once to select it, then click OK.

Excel inserts the file path into the Address field. The path looks like C:\Users\YourName\Documents\Budget.xlsx on Windows or /Users/YourName/Documents/Budget.xlsx on Mac. When someone clicks this link, the file opens on their computer — but only if they have the file in the same location. If you move the file or send the spreadsheet to someone else, the link breaks.

To avoid broken links when sharing files, keep linked files in the same folder as your spreadsheet, or use relative paths. Excel can handle this automatically if both files stay together in the same directory.

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. A new section appears showing your workbook's sheet names and a field for the cell reference.

Click the sheet name you want to link to. If you want the link to go to a specific cell on that sheet, type the cell reference in the "Cell Reference" field — for example, A1 or D15. Click OK. Now clicking this link jumps to that sheet and cell when ready, which is useful for navigation in large workbooks with multiple sheets.

Editing and Removing Hyperlinks

To change where a link points, right-click the cell containing the link and select "Edit Hyperlink". The Insert Hyperlink dialog opens again. Change the address or text as needed and click OK. The link updates without affecting any other content in the cell.

To remove a hyperlink but keep the text in the cell, right-click and select "Remove Hyperlink". The text stays exactly as it was, but it is no longer blue, underlined, or clickable. If you want to delete both the link and the text, just press Delete as you would with any cell content.

Common Problems and How to Fix Them

If you type a web address and Excel does not turn it into a clickable link automatically, the address is probably missing https:// at the start. Excel only recognizes text as a web link if it begins with http:// or https://. Add the protocol and press Enter, and Excel will format it as a hyperlink.

If a link to a file on your computer works for you but not for someone else you sent the file to, the file path is absolute — it points to a specific location on your computer that does not exist on theirs. Move both the spreadsheet and the linked file into the same folder, then re-create the link using the Browse button. Excel will use a relative path that works no matter where the folder is moved.

If clicking a link does nothing, check that you are holding Ctrl while clicking (on some systems) or that the link address is correct. You can also right-click the link and select "Edit Hyperlink" to see exactly where it points.

Frequently Asked Questions

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

Excel does not have a built-in option for this. When you click a hyperlink in Excel, it opens in your default browser or process. If you want links to open in a new tab, you can hold Ctrl while clicking (on Windows) or Cmd while clicking (on Mac) to force a new window or tab in most browsers.

What if I want to link to a specific part of a webpage, not just the homepage?

Type the full URL including the specific page path. For example, https://www.example.com/support/faq links to the FAQ page, not the homepage. Some websites also use anchor links (the # symbol) to jump to sections within a page, like https://www.example.com/page#section-name. Check the website to see if it supports this.

Can I link to an email address?

Yes. Press Ctrl+K and in the Insert Hyperlink dialog, click "E-mail Address" on the left. Type the email address in the field that appears. When someone clicks this link, it opens their default email program with that address already filled in as the recipient.

How do I know if a link is broken?

Click the link and see if it opens the intended destination. If nothing happens or you get an error, the link is broken. Right-click the link and select "Edit Hyperlink" to check the address for typos or missing parts like https://.