How to Hyperlink in Excel SharePoint

How-to basics · Updated November 18, 2026

To hyperlink in an Excel workbook stored on SharePoint, open the workbook, select a cell, press Ctrl+K in Excel for Windows, and enter or paste the destination in the link dialog. Add descriptive text if you want, then select Insert or OK. The link can point to a webpage, a SharePoint file, or a location in the workbook; people who follow it still need permission to access its destination.

The steps below are for Microsoft Excel for Microsoft 365 on Windows. Excel for the web has similar link options, with a few differences noted where they matter. It helps to decide first whether you are linking to a file or page on SharePoint, an outside website, or another place in the same workbook.

What You’ll Need

  • An Excel workbook you can edit. If it is stored in SharePoint, open it from the SharePoint library or from the workbook’s location in OneDrive for work or school.
  • The destination address. For a SharePoint file, use a link copied from SharePoint rather than guessing or manually assembling its URL.
  • Access to the destination. A hyperlink does not grant permission to view or edit a SharePoint file.
  • A current version of Excel for Microsoft 365, or Excel for the web in a browser. The ribbon labels can vary slightly as Microsoft updates the interface.

Step-by-Step

  1. Open the workbook in the right place. In SharePoint, open the document library that contains the workbook, select the file, and choose Open or Edit, then choose to open it in Excel if prompted. You can work in the desktop app or Excel for the web. Check that you can edit the workbook; if it opens read-only, ask the owner for edit access or use the appropriate editing option before adding a link. If the workbook is being shared with others, make sure you are changing the shared copy rather than a downloaded duplicate.
  2. Copy the destination link if it is a SharePoint item. In the SharePoint document library, select the destination file and choose Copy link from the command bar. You can also use the file’s ellipsis menu and choose Copy link. If a link settings panel appears, select the appropriate audience and permission, such as people who already have access or named people, subject to your organization’s options. Choose Apply if required, then copy the link. For an external website, copy its full address from the browser address bar. If linking to a location in the current workbook, you do not need a web address.
  3. Select the cell that will contain the hyperlink. Click the cell where you want people to find and activate the link. It is usually clearer to put one link in a cell in a table or list, rather than hiding it inside a cell that already contains essential information. If the cell already has text, you can use that text as the link’s display text. You can also select a word or phrase while editing a cell, but a dedicated link cell is easier to maintain in a shared worksheet.
  4. Open the link dialog. In Excel for Windows, press Ctrl+K, or select Insert > Link on the ribbon. In the dialog, choose the option for an existing file or webpage if you are linking to a web or SharePoint address. Paste the copied address into the address or link field. The dialog wording can differ slightly between Excel updates. In Excel for the web, select Insert > Link or use Ctrl+K, then enter or paste the address in the link field. On a Mac, use Command+K instead of Ctrl+K; the Insert ribbon also provides the link command.
  5. Set useful display text. In the Text to display field, enter a short label that explains what opens, such as “Open project schedule” or “View expense policy.” This is more helpful than showing a long SharePoint URL, and it gives readers context before they click. If you selected a cell containing text before opening the dialog, check that the text to display is correct. Avoid vague labels such as “click here” when several links appear together. Select Insert or OK to add the hyperlink to the cell.
  6. Add a link to another place in the workbook if needed. In desktop Excel, press Ctrl+K and select Place in This Document in the link dialog. Choose the relevant sheet and, where offered, enter a cell reference or select a defined name. Confirm the destination before inserting the link. This is useful for a contents list that takes readers to a worksheet or section. In Excel for the web, the available internal-link choices can differ; use the link dialog’s sheet or range options if shown, or create and check the internal link in desktop Excel.
  7. Optionally create the link with a formula. This can be useful when the URL is already stored in a cell or when a worksheet has many similar links. With the complete destination URL in A2, enter this in B2: =HYPERLINK(A2,"Open SharePoint file"). The displayed result in B2 is the clickable text “Open SharePoint file”; selecting it attempts to open the address in A2. The formula does not change the destination’s permissions. For a one-off link, the Insert > Link dialog is usually easier to review and update.
  8. Test the link and save your change. In desktop Excel, select the linked cell and follow the link using the prompt or the link’s context menu; depending on your Excel settings, you may need to hold Ctrl while clicking. In Excel for the web, click the link and allow the browser to open it if prompted. Check that it opens the intended item and that you are signed into the right work or school account. Save the workbook, or wait for Excel for the web to finish saving, then check that the workbook shows the latest change.

Common Mistakes

  • Using a file path instead of a SharePoint link. A path such as a local drive location works only for people whose computers can access that exact location. Paste the link copied from the SharePoint library for a file stored online.
  • Assuming the hyperlink gives people access. A URL points to a destination; it does not add its users to the destination’s permissions. Someone may be able to open the workbook but still see an access request when following its link.
  • Copying the wrong kind of link. SharePoint may offer different audiences or permissions when you copy a link. A link that works for you might not work for coworkers if it is restricted to your account or to people who already have access.
  • Making the display text too vague. Several cells labelled “Open” are hard to distinguish. Use a short, specific description that identifies the file, page, or destination.
  • Editing the visible text without changing the destination. Replacing a cell’s label does not necessarily replace the hyperlink address. Edit the link itself when the destination changes, and test it afterward.
  • Using a link copied from a temporary or personal location. Links to a downloaded copy, an email attachment, or a personal account may not be available to the workbook’s intended audience. Link to the shared, approved SharePoint item.

Tips

  • Put hyperlinks in a clearly named column, such as “Document” or “Reference,” and use consistent labels. This makes a worksheet easier to scan, filter, and maintain.
  • For a list of related SharePoint files, copy each file’s link from the library and paste it into the corresponding row. Test a few links from an account that represents the intended readers, especially if access is managed by a team or group.
  • Use a hyperlink to a stable SharePoint location. If a file is moved, renamed, or its sharing settings change, revisit the workbook and test links that point to it.
  • Keep the URL out of the visible cell when it is long. Descriptive display text is easier to read and does not prevent you from reviewing the link address through the link’s context menu or edit dialog.
  • If you need to update a link, right-click its cell and choose Edit Link or Edit Hyperlink, depending on the version, then replace the address or display text. In Excel for the web, select the linked cell and use the link pop-up or editing option that appears.
  • When a workbook contains links to sensitive material, ask the SharePoint owner or site administrator to confirm the intended audience and permissions. Do not choose a broader sharing option just to make a link work without checking your organization’s rules.

Troubleshooting

The link opens an access request or a permission error. Confirm that the destination file still exists and that you are signed into the correct Microsoft work or school account. In SharePoint, check the file’s sharing settings or ask its owner to grant the intended readers access. If the link was created for people who already have access, those people must actually have access through the site’s permissions or a direct grant. Copy a fresh link after any change to the sharing settings, then replace the old address in Excel.

The link goes to the wrong file or page. Right-click the linked cell and choose Edit Link or Edit Hyperlink to inspect the destination. Compare it with the address copied from the correct SharePoint item. If you have a URL in a cell used by a HYPERLINK formula, inspect that source cell too; changing the displayed label alone will not fix a wrong address. Replace the destination and test it again.

The link does not look clickable, or clicking only selects the cell. Check that the link was inserted rather than just typing a URL as ordinary text. Select the cell and look for a link preview, or open the link’s context menu. In desktop Excel, Ctrl+click may be needed to follow a hyperlink depending on settings; in Excel for the web, the browser may show a confirmation or opening prompt. If the link has been removed, insert it again using Insert > Link.

The link works for you but not for a coworker. This usually indicates a permissions or sign-in difference, not a problem with the cell. Ask the coworker to open the workbook and destination using the account they normally use for the SharePoint site. Check whether the link is limited to specific people, whether the coworker is included, and whether organization policies restrict sharing. A link copied from a personal OneDrive or a downloaded file can also be the wrong destination for a team workbook.

The destination changed after a file was moved. Open the SharePoint library, locate the file in its current location, and copy its current link. Edit the hyperlink in Excel to use that link. If the workbook contains many references to moved files, review them systematically rather than assuming SharePoint has updated every URL embedded in worksheet cells.

Frequently Asked Questions

Can I hyperlink to a SharePoint file from Excel?
Yes. Copy the file’s link from the SharePoint library, then add it to a cell using Insert > Link or Ctrl+K. Readers still need permission to open the file.

Does a hyperlink make a SharePoint file public?
No. A hyperlink does not change the file’s sharing permissions. Who can open it depends on the link settings, site access, and your organization’s policies.

Can I add a hyperlink in Excel for the web?
Yes. Open the workbook in a browser, select a cell, and use Insert > Link or Ctrl+K. You can add a web address and display text. Some advanced internal-link options may differ from desktop Excel.

How do I change or remove a hyperlink?
Right-click its cell in desktop Excel and choose Edit Link to change its address or display text. To remove the link while keeping the cell text, use the link’s context menu and choose Remove Hyperlink. In Excel for the web, use the link pop-up or context menu if that option is available.

Can I link to a specific worksheet or cell?
Yes. In desktop Excel, use Ctrl+K and choose Place in This Document, then select a sheet and specify a cell or defined name when available. Test the result, particularly if others will open the workbook in Excel for the web.

Why does the link open in a browser instead of Excel?
SharePoint links commonly open in a browser first, especially when they point to an online workbook or document. The destination’s settings and your browser or Office sign-in can affect whether it opens on the web or in a desktop app. This does not necessarily mean the hyperlink is broken.

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.