What a link in Excel does and when you need one
A link in Excel is text or a cell that, when you click it, takes you somewhere else — a website, another file on your computer, a different sheet in the same workbook, or even a specific cell. Instead of typing a long web address into your browser, you click the link and Excel opens it for you. This saves time when you're building a spreadsheet that references external information or when you want readers of your spreadsheet to navigate between sheets without scrolling.
You need a link when you're creating a document that other people will use and you want them to jump to information without hunting for it. A budget spreadsheet might link to supporting receipts. A project tracker might link to the detailed task list on another sheet. A price list might link to the supplier's website. Without links, readers have to remember where things are or manually type addresses.
Key Takeaways
- The simplest way to create a link is to right-click a cell, choose "Link", type or paste the web address or file path, and click OK.
- Links to other sheets in the same file use the sheet name in the address, like Sheet2!A1, so readers can jump between tabs without scrolling.
- You can make any cell a link — a cell with text, a number, or even a formula result — and the link text stays visible while the underlying address stays hidden.
- Changing what a link points to is as straightforward as right-clicking it and editing the address; you do not have to delete and recreate it.
Creating a link to a website
Click the cell where you want the link to appear. Type the text you want readers to see — for example, "Company Website" or "Pricing Page". You do not have to type the web address; that goes in the link itself, not in the cell.
Right-click the cell and select "Link" from the menu. (In some versions of Excel, this option says "Insert Link" or "Edit Link".) A dialog box opens. In the field labeled "Address" or "URL", paste or type the full web address, starting with https:// or http://. If you leave off the protocol, Excel may not recognize it as a web link. Click OK. The text in the cell now appears underlined and in blue, which signals to readers that it is clickable.
To test the link, hold Ctrl and click it. Your default web browser opens and loads the page. If the link does not work, right-click it again, select "Link", and check that the address is spelled correctly and includes the protocol at the start.
Creating a link to another file on your computer
This works the same way as a web link, but instead of a web address, you point to a file. Click the cell, type the display text (like "Q3 Budget" or "Supporting Documents"), then right-click and select "Link".
In the dialog, you have two options. You can type the file path directly — for example, C:\Users\YourName\Documents\Budget.xlsx on Windows or /Users/YourName/Documents/Budget.xlsx on Mac. Or you can click the folder icon button in the dialog to browse your computer and select the file. Browsing is safer because Excel fills in the path for you and you avoid typos.
When someone clicks this link, Excel opens the file. If the file has moved or been deleted, the link breaks and clicking it produces an error. If you move the spreadsheet with the link to a different folder, the link may break unless you used a relative path (a path that does not start with the drive letter or full folder name). For shared files that people will use on different computers, web links are more reliable than file links.
Creating a link to another sheet in the same workbook
This is the most useful type of link for spreadsheets you build for others to read. Instead of making readers scroll through tabs or remember which sheet has what, you can link directly to a cell on another sheet.
Click the cell where you want the link, type the display text (like "See detailed breakdown" or "Jump to summary"), then right-click and select "Link". In the Address field, type the sheet name followed by an exclamation mark and the cell address. For example, to link to cell A1 on a sheet named "Details", type Details!A1. If the sheet name has spaces, put it in single quotes: 'Q3 Data'!A1.
When someone clicks this link, Excel jumps to that cell on that sheet and selects it. This is much faster than asking readers to find the right tab and scroll to the right location. You can link to any cell on any sheet in the workbook, including cells that contain formulas or data that changes.
Changing or removing a link
Right-click the linked cell and select "Link" or "Edit Link". The dialog opens with the current address showing. You can change the address, change the display text, or remove the link entirely. To remove the link while keeping the text, click "Remove Link" or a similar button (the exact name varies by Excel version). The cell text stays, but it is no longer clickable.
If you want to change just the text that readers see without changing where the link points, right-click the cell, select "Edit", and type new text. The link address does not change. This is useful when you realize the link text is confusing but the destination is correct.
Why links sometimes break and how to fix them
A link breaks when the destination no longer exists or has moved. A website link breaks if the site goes down or the page is deleted. A file link breaks if the file is moved, renamed, or deleted. A link to another sheet breaks if you delete that sheet.
When you click a broken link, you get an error message. To fix it, right-click the link, select "Link", and update the address to point to the correct location. If you are not sure where the file moved to, use the browse button to find it. For web links, check that the website is still online and the page still exists by visiting it in your browser first, then updating the link address.
If you have many links in a spreadsheet and several are broken, there is no automatic way to fix them all at once. You have to fix each one individually. This is one reason to use links sparingly and to keep file names and sheet names stable once other people start using your spreadsheet.
Making links look and behave the way you want
By default, Excel makes linked text blue and underlined. If you want to change how a link looks, you can format it like any other cell. Right-click the linked cell, select "Format Cells", and change the font color, size, or style. The link still works; it just looks different. This is useful when the blue underline does not fit your spreadsheet design.
You can also create a link from a cell that contains a formula or a number. For example, if a cell shows a calculated total, you can make that number a link to a supporting sheet. The formula or calculation still runs; the link just adds a destination when someone clicks the result.
One thing you cannot do is make a link that opens a new browser tab instead of the current one. Excel always opens links in your default browser, and the behavior depends on your browser settings, not on Excel.
Frequently Asked Questions
Can I create a link from a cell that already has text in it?
Yes. Right-click the cell with the text, select "Link", and enter the address. The text stays visible and becomes clickable. You do not have to retype or replace anything.
What happens if I copy a cell that has a link?
The link copies too. If you paste it into another cell, that cell becomes a link to the same destination. If you move the linked cell to a different location in the spreadsheet, the link still works because it points to an absolute address (a website, file path, or sheet name), not to the cell's position.
Can I make a link that sends an email when someone clicks it?
Yes. Right-click the cell, select "Link", and in the Address field, type mailto:email@example.com. When someone clicks it, their default email program opens with a new message addressed to that email. Replace email@example.com with the actual address.
How do I know if a link is broken before I send the spreadsheet to someone?
Test it. Hold Ctrl and click each link. If it opens the correct destination, it works. If you get an error or it opens the wrong page or file, the link is broken and you should fix it before sharing the spreadsheet.
Can I create a link to a specific cell in another Excel file?
Yes, but it is more complex. You have to include the file path and the sheet name and cell address. For example: C:\Documents\Budget.xlsx#'Sheet1'!A5. The file must exist at that path for the link to work. If you move the file, the link breaks. For this reason, web links or links within the same workbook are usually simpler.