The two ways to add a link in Excel

Excel lets you turn text or a cell into a clickable link in two ways: you can link to a website, or you can link to another place within the same spreadsheet. The fastest method is the keyboard shortcut Ctrl+K (or Cmd+K on Mac), which opens a dialog box where you type or paste the address. The second method is right-clicking a cell and selecting "Link" from the menu — this does the same thing but takes an extra step.

Both methods work the same way once the dialog opens. You paste the web address or file path, decide what text should show in the cell, and click OK. The cell then displays that text in blue and underlined, and clicking it opens the link.

The reason to use links in a spreadsheet is to connect related information without cluttering the sheet itself. A budget spreadsheet might link to the vendor's website. A project tracker might link to the actual project file stored elsewhere. A contact list might link to email addresses or LinkedIn profiles.

Key Takeaways

  • Press Ctrl+K (or Cmd+K on Mac) to open the link dialog, then paste the web address and click OK.
  • The cell will display blue underlined text, but you can change what text appears by typing in the "Display text" field before clicking OK.
  • You can link to websites, email addresses, files on your computer, or other cells within the same spreadsheet.
  • To edit or remove a link later, right-click the cell and choose "Edit Link" or "Remove Link".

Linking to a website

Start by clicking the cell where you want the link to appear. Then press Ctrl+K to open the "Insert Hyperlink" dialog box. In the field labeled "Address", paste the full web address — for example, https://www.example.com. If you just type "example.com" without the https://, Excel will usually add it for you, but pasting the full address is more reliable.

Next, look at the field labeled "Display text". This is what will actually show in your cell. By default, Excel fills this with whatever you pasted in the Address field. If you want the cell to show something shorter or more readable — like "Click here" or "Vendor site" instead of the full URL — delete what's in the Display text field and type what you prefer. Then click OK.

The cell now shows your display text in blue and underlined. When you or anyone else opens this spreadsheet and clicks that cell, it will open the website in your default browser.

Linking to an email address

Click the cell where you want the email link. Press Ctrl+K to open the Insert Hyperlink dialog. In the Address field, type mailto: followed when ready by the email address, with no space — for example, mailto:contact@example.com. The word "mailto:" tells Excel this is an email link, not a website.

In the Display text field, type what you want the cell to show — usually just the email address itself, or a name like "Send feedback". Click OK. Now when someone clicks that cell, it will open their default email program with the address already filled in.

Linking to another cell in the same spreadsheet

This is useful when your spreadsheet has multiple sheets or when you want to jump from a summary section to detailed data further down. Click the cell where you want the link. Press Ctrl+K. In the Insert Hyperlink dialog, look for a button or section labeled "Place in This Document" or "Link to" — the exact wording depends on your Excel version.

Click that button. A new panel will appear showing the sheets in your workbook and the named ranges (if you have created any). Select the sheet you want to link to, then either click a specific cell or type the cell reference — for example, A1 or Sheet2!C5. In the Display text field, type what should show in the cell, like "Go to summary" or "Details". Click OK.

Now clicking that cell will jump to the target location within the same file. This is especially helpful in large spreadsheets where readers need to navigate between sections.

Linking to a file on your computer

Click the cell where the link should appear. Press Ctrl+K. In the Insert Hyperlink dialog, look for a button labeled "Browse" or a folder icon. Click it to open a file browser. Navigate to the file you want to link to — it can be another Excel file, a Word document, a PDF, or any other file type. Select the file and click OK or Open.

The file path will now appear in the Address field. In the Display text field, type what you want the cell to show — usually the file name or a description like "Full report" or "Supporting data". Click OK. When someone clicks this link, it will open that file on their computer. If the file has moved or been deleted, the link will break and show an error.

Editing and removing links

To change a link after you have created it, right-click the cell containing the link. A menu will appear. Select "Edit Link" (or "Edit Hyperlink" depending on your Excel version). The Insert Hyperlink dialog opens again, and you can change the address, the display text, or both. Click OK when you are done.

To remove a link entirely while keeping the text in the cell, right-click the cell and select "Remove Link" or "Delete Hyperlink". The cell will no longer be blue and underlined, and clicking it will no longer open anything — it will just select the cell as normal. The text itself stays in the cell.

If you want to delete both the link and the text, straightforward press Delete while the cell is selected.

Common mistakes and how to avoid them

The most common mistake is forgetting the https:// at the start of a web address. Excel sometimes adds it automatically, but not always. If you paste a link and it does not work when you click it, right-click the cell, edit the link, and make sure the address starts with https:// or http://.

Another mistake is typing a display text that is too long. If your display text is longer than the cell width, it will either overflow into the next cell or be cut off. Keep display text short — usually one to four words.

When linking to files on your computer, remember that the link only works if the file stays in the same location. If you move the file to a different folder or rename it, the link will break. For shared spreadsheets, consider using web links instead, or store files in a shared cloud location that does not move.

Frequently Asked Questions

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

No — Excel links always open in your default browser or process, and you cannot control whether they open in a new tab or the same window. That behavior is controlled by your browser settings, not by Excel. If you want the link to open in a new tab, you can hold Ctrl (or Cmd on Mac) while clicking the link in most browsers.

What if the link text is longer than the cell?

The text will either overflow into the next cell if it is empty, or be cut off if the next cell has content. Widen the column by double-clicking the border between column headers, or manually drag it wider. You can also shorten the display text to something like "Link" or "Details".

Can I copy a cell with a link to another cell?

Yes. Select the cell with the link, press Ctrl+C to copy, click the destination cell, and press Ctrl+V to paste. The link will copy to the new cell. If you want to copy just the text without the link, right-click and select "Paste Special", then choose "Text" or "Values".

Why does my link show the full URL instead of my display text?

You likely left the Display text field empty when you created the link. Right-click the cell, select "Edit Link", and type what you want to show in the Display text field. Click OK. The cell will now show your chosen text instead of the address.

Can I link to a specific cell in another Excel file?

Yes, but it is more complex. When you browse for the file in the Insert Hyperlink dialog, after selecting the file, you can type a cell reference in the Address field — for example, [OtherFile.xlsx]Sheet1!A1. However, this only works if both files are open or if the other file is in a known location. For most users, linking to the file itself (which opens it) is simpler and more reliable.