How to Create a Hyperlink in Excel: Links to Files and Pages

How-to basics · Updated November 18, 2026

To create a hyperlink in Excel for Microsoft 365 on Windows, select a cell, press Ctrl+K, choose the kind of link, enter its destination, and select OK. The cell becomes clickable, letting you open a website, file, email draft, or another location in the workbook. You can also use the ribbon’s Insert > Link command.

Before you begin, decide where the link should go and what text should appear in the cell. A useful label such as “Project brief” is often easier to understand than a long web address. If you are linking to a file, make sure you know where it is saved and consider whether other people who use the workbook can access that location.

What You’ll Need

  • An Excel workbook you can edit in Microsoft Excel for Microsoft 365 on Windows.
  • The destination: a website address, file location, email address, or cell reference in the workbook.
  • Optional display text to make the link clear and descriptive.

Step-by-Step

  1. Select the cell for the link. Click the cell where you want the clickable text to appear. You can use a blank cell or replace existing text. If you select a cell with existing content, Excel may use that content as the link’s display text; you can change it in the link dialog. To add a link to only part of a sentence inside a cell, edit the cell and select the characters first. Excel’s link behavior for partially formatted text can vary, so a dedicated link cell is usually simpler to maintain.
  2. Open the Insert Link dialog. Press Ctrl+K, or go to Insert > Link on the ribbon. Depending on the Excel window size, Link may appear as a button or within the Links group. You can also right-click the selected cell and choose Link. If the dialog offers a “Text to display” field, enter a short label that explains the destination, such as “Open the schedule” or “Supplier website.”
  3. Choose the destination type. The dialog provides options for linking to an existing file or web page, a place in the current document, a new document, or an email address. Select the option that matches your intended destination. The fields change depending on the type you choose, so check the selection before entering the address. For most website links, use the existing file or web page option.
  4. Enter a website address. Select the existing file or web page option and type or paste the complete URL in the Address field. Include the protocol, such as https://, when available. For example, use https://www.example.com, not just a company name. If you copied the address from a browser, check that it does not contain unwanted spaces or punctuation at the end. Review the display text as well, then select OK.
  5. Link to a file on your computer or network. In the existing file or web page option, browse to the file or enter its location in the Address field. Choose a label that identifies the file, such as “Quarterly report.” Select OK to add the link. A link to a file stored on your computer may work only for you. A link to a shared network folder or cloud location is more suitable when collaborators need access, provided they have permission and the path is available to them.
  6. Link to a place in the workbook. Choose Place in This Document in the link dialog. Select the worksheet from the list, then enter the destination cell reference if prompted. For example, you could link a contents cell to cell A1 on a sheet named Summary. Confirm the destination and select OK. This is handy for navigation in a workbook with several sheets, but use a clear label so people know which section the link opens.
  7. Create an email link, if needed. Choose the email address option and enter the recipient’s address. You can also add a subject if the dialog provides a subject field. After selecting OK, clicking the link opens the computer’s configured email application or email handler and starts a draft; it does not send the message automatically. Check the address carefully, especially if the workbook will be used to contact customers or suppliers.
  8. Confirm the link and test it. Select OK to close the dialog. The cell usually displays underlined, colored text, although its appearance depends on the workbook’s theme and formatting. In Excel for Windows, clicking a hyperlink may require holding Ctrl while you click, depending on your Excel settings. Follow the on-screen prompt, or right-click the cell and choose Open Hyperlink. Check that it reaches the intended destination before sharing the workbook.
  9. Edit or remove the link when necessary. Right-click the linked cell and choose Edit Hyperlink to change its destination or display text. To remove only the link but keep the visible text, right-click and choose Remove Hyperlink. If you want to clear both the link and its text, select the cell and delete its contents. Check the wording and destination after editing, since a correct-looking label can still point to the wrong place.

Excel for Mac has a similar Insert Link command, though the dialog layout may differ; use Insert > Link or press Command+K. In Excel for the web, select a cell and use Insert > Link or Ctrl+K on Windows; the available destination options can differ from the desktop app. When working in a shared workbook, test the link in the same environment your readers will use.

Common Mistakes

  • Entering an incomplete web address: A URL without the right domain or protocol may not open correctly. Copy the full address from the browser’s address bar and check it before saving.
  • Using vague display text: A cell that says “Click here” gives little context, especially when printed or read by someone using assistive technology. Prefer a label that describes the destination, such as “Installation instructions.”
  • Linking to a local file that others cannot reach: A path such as a file in your personal Downloads folder is meaningful only on your computer. Store shared files in a location available to collaborators and make sure their permissions allow them to open it.
  • Assuming a hyperlink sends email: An email link normally opens a draft in an email program. The person still has to review and send the message.
  • Testing only the label: Display text can look right even when the address is mistyped or outdated. Open the link and verify the destination itself.
  • Confusing a URL with a cell reference: A web address belongs in the website or existing file destination field. A worksheet and cell destination should be set through Place in This Document.

Tips

  • Make labels specific: “2026 product catalog” is more informative than “Open link.” Keep labels concise enough to fit the column, and widen the column or wrap text if needed.
  • Use a consistent style: If a sheet contains many links, use consistent wording and formatting so readers can recognize navigation links. Excel’s built-in hyperlink appearance may change with the workbook theme.
  • Keep shared destinations stable: If a file is moved or renamed, links to its old path can stop working. For team workbooks, use a stable shared location and update the workbook whenever the destination changes.
  • Use workbook links as navigation: A contents sheet with links to major worksheets can make a large file easier to use. Include useful section names rather than relying on sheet tabs alone.
  • Check links before distributing: Test a sample of web, file, and in-workbook links after moving or copying a workbook. A link that worked from its original folder may behave differently after the workbook is relocated.
  • Keep accessibility in mind: Descriptive link text is easier to understand when read out of context. Avoid relying only on color to indicate that a cell is clickable.

Troubleshooting

The link does not open when I click it. Excel may require Ctrl+click on Windows. Look for a prompt near the cell and follow it, or right-click the cell and select Open Hyperlink. If that option is unavailable, confirm that the cell actually contains a hyperlink rather than plain text that resembles one.

The browser says the page cannot be found. Right-click the cell, choose Edit Hyperlink, and inspect the address. Look for a missing character, a space, a pasted period, or an old page address. If the site requires a sign-in, try opening it in a browser where you are signed in and check that you have access.

A linked file works for me but not for a colleague. The link may point to a location on your computer, a mapped drive your colleague does not have, or a folder with restricted permissions. Put the file in an approved shared location, confirm that the colleague can access it, and replace the old link with the shared address. Do not assume that attaching the workbook also shares every file it links to.

The link opens the wrong worksheet or cell. Edit the hyperlink and check the selected sheet and cell reference under Place in This Document. Sheet names with spaces or punctuation may appear differently in the dialog, so choose the sheet from the list instead of typing its name from memory. Test the corrected link before distributing the workbook.

The Link command or keyboard shortcut is unavailable. Make sure a worksheet cell is selected and that the workbook is not in a mode that prevents editing. If the shortcut does not work, use Insert > Link from the ribbon or the right-click menu. The exact dialog and available destinations can vary in Excel for the web, so try the desktop app if you need an option that is missing.

Frequently Asked Questions

Can I create a hyperlink without using the Insert Link dialog?

Yes. You can paste a web address into a cell, and Excel may recognize it as a hyperlink when you confirm the entry. The behavior can depend on Excel’s formatting and AutoCorrect settings. Using Insert > Link gives you more control over the displayed label and destination, so it is the more reliable choice when presentation matters.

How do I make the link text different from the web address?

Open the Insert Link dialog and enter the wording you want in Text to display, then enter the full URL in the address field. For an existing link, right-click its cell, choose Edit Hyperlink, and change the display text while leaving the correct destination in place.

Can a hyperlink jump to a different sheet in the same workbook?

Yes. In the Insert Link dialog, choose Place in This Document, select the worksheet, and specify the cell to open. This creates a workbook navigation link and does not require a web address or a separate file.

Can I link to a file stored in OneDrive or SharePoint?

Yes, if you have a usable link or shared location and the people opening the workbook have permission. Insert it as an existing file or web page destination. For a shared cloud file, a sharing URL is often more reliable than a local synchronized folder path, but check your organization’s sharing rules and test access as a collaborator.

How do I remove a hyperlink but keep the words in the cell?

Right-click the linked cell and choose Remove Hyperlink. Excel removes the clickable destination while leaving the displayed text. If you choose to delete the cell’s contents instead, the text will be removed too.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.