The three ways to add a clickable link in Excel

Excel lets you turn text or numbers into clickable links in three ways: by typing a web address directly, by using the Insert Link dialog, or by right-clicking on a cell. The fastest method depends on what you're linking to and whether you want the link text to look different from the actual web address.

The simplest approach is to type a full web address starting with http:// or https:// into a cell. Excel recognizes it automatically and converts it to a blue underlined link. If you type https://www.housing.gov, that exact text becomes clickable. You can then click it to open the website.

If you want the link text to say something different from the actual address — for example, showing "Housing Resources" instead of the full URL — you need the Insert Link dialog. This is also the method to use when linking to files on your computer or to a specific location within the same spreadsheet.

Key Takeaways

  • Type any web address starting with http:// or https:// directly into a cell, and Excel automatically converts it to a clickable link.
  • Use the Insert Link dialog (Ctrl+K on Windows, Command+K on Mac) when you want the visible text to differ from the actual web address or file path.
  • Right-click an existing link and choose Edit Link to change where it points without retyping the whole thing.
  • Links in Excel work the same way whether you save as .xlsx or .xls, but they may not work if you convert the file to .csv or plain text format.

Adding a link by typing the web address directly

Click the cell where you want the link. Type the full web address, starting with http:// or https://. Press Enter. Excel detects the format and automatically turns the text blue and underlined.

This method works when ready and requires no extra steps. The downside is that the cell displays the full URL, which can be long and hard to read. If you're building a spreadsheet that other people will use, a long URL takes up space and looks cluttered. For your own reference or internal use, this is the fastest route.

Using the Insert Link dialog to customize link text

Click the cell where you want the link. Press Ctrl+K on Windows or Command+K on Mac. The Insert Hyperlink dialog opens.

In the dialog, you will see a field labeled "Text to display" at the top. Type what you want people to see in the cell — for example, "Click here for housing resources" or "Rent information programs". Below that, in the "Address" field, paste or type the full web address. Click OK. The cell now shows your custom text as a blue underlined link, and clicking it opens the address you entered.

This method takes a few extra seconds but produces a cleaner, more readable spreadsheet. Use it when you're sharing the file with others or when the URLs are long and would clutter your data.

Linking to files on your computer or network

Open the Insert Hyperlink dialog (Ctrl+K or Command+K). On the left side of the dialog, click Existing File or Web Page if it is not already selected. Click the folder icon next to the Address field. A file browser opens.

Navigate to the file you want to link to — a PDF, Word document, another Excel file, or any other file type. Click it once to select it, then click Open. The file path appears in the Address field. Type your custom display text in the "Text to display" field, then click OK.

When someone clicks this link, their computer opens the file in the default program for that file type. If the file is on a shared network drive, the link works for anyone with access to that drive. If the file is only on your computer, the link will not work for others unless they have the file in the same location.

Linking to a specific cell or sheet within the same spreadsheet

Open the Insert Hyperlink dialog (Ctrl+K or Command+K). On the left side, click Place in This Document. A list of sheets in your workbook appears on the right.

Click the sheet name you want to link to. If you want to link to a specific cell rather than the top of the sheet, type the cell reference in the "Cell Reference" field — for example, A15 or D20. Type your display text in the "Text to display" field. Click OK. Now clicking the link jumps to that sheet and cell.

This is useful in large spreadsheets where you want a table of contents at the top that links to different sections, or when you're building a workbook with multiple sheets and want readers to navigate between them easily.

Editing or removing a link

Right-click a cell containing a link. A menu appears. Click Edit Hyperlink to open the Insert Hyperlink dialog again. You can now change the address, the display text, or both. Click OK to save your changes.

To remove a link entirely while keeping the text, right-click the cell and click Remove Hyperlink. The text stays in the cell but is no longer blue or clickable. To delete both the link and the text, straightforward press Delete while the cell is selected.

What happens when you save or share a spreadsheet with links

Links work in Excel files saved as .xlsx (the standard format) and .xls (older Excel format). Both formats preserve links when you save and when you share the file with others.

If you save the file as .csv (comma-separated values), the links are removed and only the display text remains. If you need to preserve links, keep the file in .xlsx or .xls format. When you email the file or upload it to a shared drive, links continue to work as long as the addresses are still valid and the linked files have not moved.

If a link points to a file on your computer and you send the spreadsheet to someone else, that link will not work for them unless they have the file in the exact same location. For shared files, use links to web addresses or to files on a shared network drive that everyone can access.

Frequently Asked Questions

Can I make a link open in a new tab or window instead of replacing my spreadsheet?

Excel does not have a built-in setting for this. When you click a web link in Excel, it opens in your default browser, and the spreadsheet stays open in the background. If you want to keep the spreadsheet visible while browsing, manually right-click the link and choose "Open Link in New Tab" (if your browser supports it) or straightforward switch back to Excel after the browser opens.

What if the link address has special characters or spaces?

Use the Insert Hyperlink dialog rather than typing the address directly. The dialog handles special characters and spaces correctly. If you type the address directly into a cell, Excel may not recognize it as a link if it contains spaces or certain symbols. Always use the dialog when the address is complex.

Can I link to a specific page in a PDF file?

Excel does not support linking to a specific page within a PDF. You can link to the PDF file itself, and it opens to the first page. The person reading it can then navigate to the page they need. If you need to direct people to a specific section, consider using a web link instead, or add a note in the cell explaining which page to view.

How do I know if a link is broken?

Click the link. If it does not open anything or shows an error message, the address is no longer valid or the file has been moved. Right-click the link, click Edit Hyperlink, and check that the address is correct. If the link points to a file, verify that the file still exists in that location.

Can I copy a cell with a link and paste it into another cell?

Yes. Click the cell with the link, press Ctrl+C (or Command+C on Mac), click the destination cell, and press Ctrl+V (or Command+V). The link copies exactly as it is. If you want to paste only the text without the link, right-click and choose Paste Special, then select Text Only.