The two ways to add a clickable link in Excel

Excel has two methods to create links: hyperlinks that point to websites, email addresses, or other files, and formulas that build links from cell data. For most people, the hyperlink method is what you need — it takes 10 seconds and produces a blue underlined link that opens when clicked.

The formula method is for situations where you're building hundreds of links from data in other cells, like creating a list of product pages where the URL changes based on a product ID. If you're just linking to a few websites or documents, use the hyperlink method.

Key Takeaways

  • Right-click a cell, choose Insert Link, and paste the URL or type an email address to create a clickable hyperlink in seconds.
  • The link text (what readers see) can be different from the actual URL it points to — you can make a cell say "Click here" while linking to a long web address.
  • You can link to other sheets within the same workbook, external files on your computer, or websites.
  • The HYPERLINK formula lets you build links automatically when you have many URLs stored in other cells or need to construct them from pieces of data.

Creating a hyperlink with the right-click method

Click the cell where you want the link to appear. Type the text you want readers to see — this could be "Visit our website", a company name, or anything else. Then right-click that cell and select Insert Link (or use Ctrl+K on Windows, Command+K on Mac).

A dialog box opens. In the "Address" field, paste the full URL starting with http:// or https://. If you're linking to an email address, type mailto: followed by the address with no spaces — for example, mailto:contact@company.com. Click OK. The text in the cell turns blue and underlined, and clicking it opens the link.

The key thing to understand: the text you typed is what shows in the cell, but the address you entered is where the link actually goes. You can make a cell display "Click here" while the link points to a 200-character URL. This is useful when your actual URLs are long or ugly.

Linking to other sheets or files on your computer

The Insert Link dialog has a left sidebar with options beyond "Web Page". Click Place in This Document to link to another sheet in the same workbook. A list of sheet names appears — select the one you want, and optionally click a cell reference to link to a specific location on that sheet.

To link to a file on your computer — a PDF, Word document, or another Excel file — click Existing File or Web Page and use the file browser to navigate to it. The link will open that file when clicked. Be aware that if you move the file to a different folder later, the link breaks.

Using the HYPERLINK formula for bulk links

If you have a spreadsheet with product IDs in column A and you need to create links to product pages for all 500 items, typing each link manually is not practical. The HYPERLINK formula builds links automatically from cell data.

The formula structure is: =HYPERLINK(address, display_text). The address is the URL (or a cell reference containing a URL), and display_text is what shows in the cell. For example, if cell A2 contains a product ID like "SKU-4521", you could write:

=HYPERLINK("https://shop.example.com/product/"&A2, A2)

This creates a link that points to https://shop.example.com/product/SKU-4521 and displays "SKU-4521" in the cell. The & symbol joins text together — so the formula takes the base URL, adds the product ID from A2, and creates the full address. Copy this formula down your column and Excel builds a link for every row automatically.

Editing or removing a link

To change where a link points, right-click the cell and select Edit Link. The Insert Link dialog opens again — update the address and click OK. To remove the link but keep the text, right-click and select Remove Link. The cell text stays, but it's no longer blue or clickable.

If you used a HYPERLINK formula and need to change the destination, edit the formula in the formula bar at the top of the screen. Change the URL portion and press Enter.

Common problems and fixes

If you type a URL and it doesn't turn blue, Excel may not have recognized it as a link. Make sure you included http:// or https:// at the start. If you used the Insert Link dialog, check that the address field is filled in correctly — sometimes the dialog closes without saving if you click OK too quickly.

If a link opens the wrong page, right-click and edit it to verify the address is correct. If you're using a HYPERLINK formula and it shows an error, check that the formula syntax is correct — the address and display_text should be separated by a comma, and text should be in quotation marks.

Links in Excel files sometimes break when you share the file with someone else, especially if the file is moved to a different folder or if it contains links to files on your computer that the other person doesn't have. Links to websites are more reliable because they don't depend on your file location.

When to use links instead of other Excel features

Links are useful when you want readers to navigate somewhere without leaving the spreadsheet — they're faster than copying a URL into a browser. They're also good for building navigation within a large workbook, linking from a summary sheet to detailed sheets below.

If you're building a tool that other people will use, links make it obvious what's clickable and where it goes. A spreadsheet with a "View Full Report" link is more user-friendly than one where people have to guess they should copy a cell value and paste it somewhere else.

Frequently Asked Questions

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

Excel links always open in your default browser or process — you can't control whether they open in a new tab or the same window. Once the link opens, your browser settings determine the behavior. If you need more control over how links behave, you're working at the edge of what Excel is designed for.

What happens to links when I save the file as a PDF?

Links stay clickable in PDFs created from Excel. When you export to PDF, hyperlinks convert to PDF links that work the same way. Links to other sheets in the workbook become page references in the PDF.

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

Yes. In the Insert Link dialog, click Existing File or Web Page, select the file, then click a button labeled "Current Folder" or similar to access the file browser. After selecting the file, you can specify a cell reference like Sheet1!A5 to link to a specific location.

Why does my HYPERLINK formula show the formula text instead of a link?

Excel is displaying the formula as text instead of running it. Right-click the cell, select Format Cells, go to the Number tab, and change the format from Text to General or Number. Then press Enter to recalculate the formula.

Can I link to a file that's stored in the cloud?

Yes, if the file is in OneDrive, Google Drive, or another cloud service. Use the full URL to the file (the share link), and the hyperlink will work as long as you have internet access. Be careful with share settings — if the link recipient doesn't have permission to view the file, the link won't work for them.