Copy Link in Excel: Steps for Cells, Files, and Sheets

How-to basics · Updated November 20, 2026

To copy a link in Excel, right-click the cell containing the hyperlink and choose Copy Hyperlink. To share the workbook itself, use Share > Copy Link; to make a link to a worksheet or cell, add an internal link first, then copy it. These methods copy different kinds of links, so choose the one that matches what you want someone to open.

What You’ll Need

  • Excel for Microsoft 365 on Windows, and the workbook or hyperlink you want to copy.
  • For a shareable workbook link, save the file to OneDrive or SharePoint and sign in to the Microsoft account or organization that can access it.
  • For a link to a specific sheet or cell, know the worksheet name and cell address, such as Summary!A1.
  • A destination for the copied link, such as an email, chat, document, or another cell.

Step-by-Step

  1. Decide what you want the link to open. A hyperlink in a cell may lead to a website, a file, or another place in the workbook. A workbook sharing link opens the Excel file for people who have permission. An internal link jumps to a particular sheet or cell. These are not interchangeable: copying a cell does not necessarily copy just its web address, and copying a sharing link does not create a link to one particular cell.
  2. Copy the target of an existing hyperlink. In Excel for Windows, right-click the cell that contains the hyperlink and choose Copy Hyperlink from the context menu. The command copies the link address, rather than the cell’s displayed label. Paste it into a browser address bar, message, or other destination with Ctrl+V. If the cell is part of a table, take care to right-click the actual linked cell rather than a nearby cell.
  3. Use the link’s address if Copy Hyperlink is not available. Right-click the linked cell and choose Edit Hyperlink or Edit Link, depending on the wording shown in your Excel version. In the dialog, find the Address field. Select and copy the address, then close the dialog with Cancel if you do not intend to change the link. This approach is useful when the context menu does not show a copy command or when you need to inspect the destination before sharing it.
  4. Copy a link to the workbook for sharing. First save the workbook to OneDrive or SharePoint. Select Share near the upper-right corner of Excel, then choose Copy Link in the sharing window. Depending on your organization’s settings, Excel may let you choose whether the link works for specific people, people in your organization, or anyone with the link. Choose the narrowest access that suits the task, review whether recipients can edit or only view, and then copy the link. Paste it into your message and tell recipients what access they have.
  5. Create a link to a sheet or cell before copying it. Select the cell that should contain the link, then press Ctrl+K or choose Insert > Link. In the link dialog, select Place in This Document (or the similarly named option), choose the target worksheet, and enter the destination cell reference if needed. Confirm with OK. Excel makes the selected cell a clickable internal hyperlink. Right-click that new hyperlink and choose Copy Hyperlink to copy its target. The link works within the workbook, so the recipient generally needs access to the same workbook for it to be useful.
  6. Paste and verify the result. Paste the copied link into the intended app or location. If you are putting it in another Excel cell, select that cell and press Ctrl+V. For a link pasted into a message or browser, check that the entire address appears and that it opens the expected destination. If the link is private, test it while signed in as an authorized user or ask a recipient to confirm access; a copied address alone does not grant permission.

On Mac: The same general options are available, although dialog labels or context-menu items can differ by Excel version. Use Command+K to open the link dialog and Command+C and Command+V to copy and paste. Right-clicking can be done with a two-finger click on a trackpad. For a shared workbook, use the Share control and copy the link in the sharing dialog. In Excel for the web, use the workbook’s Share button for a file link; menus for editing or copying an existing cell hyperlink may differ from the Windows desktop steps.

Common Mistakes

  • Copying the cell instead of its hyperlink. Pressing Ctrl+C after selecting a linked cell copies the cell and its contents for Excel, not necessarily a plain URL. Use Copy Hyperlink or copy the address from the Edit Hyperlink dialog when you need only the destination.
  • Sharing a local file path as if it were an online link. A path such as C:\Reports\Budget.xlsx points to a location on one computer. It will not normally open for someone else. Store the workbook in OneDrive or SharePoint and use Share > Copy Link to create a link that can be shared subject to permissions.
  • Assuming a link gives everyone access. The recipient still needs permission to the workbook, website, or file at the other end. A OneDrive or SharePoint link may be restricted to named people or to your organization. Check the link’s access settings rather than changing them to a broader option automatically.
  • Editing the link while trying to copy it. In the hyperlink dialog, changing the address and selecting OK modifies the workbook. If your goal is only to get the URL, copy the text in the Address field and close with Cancel.
  • Expecting a cell link to work in every context. An internal link points to a location inside a particular workbook. If you send only that link without the workbook, or the recipient opens a different copy, it may not lead to the intended place.

Tips

  • Give the pasted link context. When sending a workbook link, say whether it is view-only or editable and name the file. When sending an internal link, identify the sheet or section it leads to so the recipient knows what to expect.
  • Choose access before copying. For cloud files, set the intended audience and permission in the share dialog first. If you change those settings afterward, review or copy the updated link again rather than assuming an earlier link has the access you want.
  • Keep a readable label in Excel. A cell can display helpful text such as “Open the instructions” while linking to a longer address. The label is not the URL itself; use the hyperlink-copy command or address field when someone specifically asks for the web address.
  • Check the destination before you distribute it. If a link comes from an unfamiliar workbook or email, inspect its address before opening or forwarding it. This is especially useful for links that look similar to a trusted company or website address.
  • Use the right link for the audience. A website hyperlink is suitable for a public page, while a OneDrive or SharePoint sharing link is for the workbook. A private file path is usually unsuitable for external recipients, and an internal sheet link is not a substitute for granting access to the file.
  • Preserve the source workbook. When you paste a link into another cell or document, check that it remains clickable. Some applications paste plain text, while others automatically format a recognized address as a hyperlink.

Troubleshooting

There is no Copy Hyperlink option. Confirm that the selected cell actually contains a hyperlink; blue, underlined text can also be ordinary formatting. Right-click and look for Edit Hyperlink or Edit Link, then copy the destination from the Address field. If the cell is not linked, create a hyperlink first with Ctrl+K.

The copied link pastes as a label or cell content. You may have used the regular copy command. Return to the source cell and choose Copy Hyperlink, or copy the address directly from the link dialog. When pasting into a particular app, check whether it has a paste option for plain text or a link; app behavior can vary.

The workbook link asks the recipient to request access. Open Share and review the link settings and recipient permissions. If the link is restricted, add the intended recipient or create an appropriate organization-level link if your policies allow it. Do not select an “anyone” option unless that level of access is acceptable. Some work or school accounts prevent changing these settings, in which case contact the file owner or administrator.

Copy Link is unavailable or the file is not online. Save or move the workbook to OneDrive or SharePoint, wait for it to upload, and then open the sharing controls again. If the organization blocks cloud sharing, use an approved file-sharing method rather than sending a local drive path. A link to a local file will only work for people who can access that same location.

An internal link opens the wrong place or does nothing. Check that you selected the correct worksheet in the link dialog and that the cell reference is valid. Sheet names with spaces or punctuation can make manual address entry easy to mistype, so choose the sheet from the dialog where possible. Also confirm that the recipient opened the workbook containing that internal link, not a separate or older copy.

The link opens a sign-in page or an error. This may be normal if the destination requires an account, or it may mean the recipient lacks permission. Verify the address, confirm the file has not moved or been deleted, and test access while signed in with the account the recipient is expected to use. Ask the owner to grant access if needed.

Frequently Asked Questions

How do I copy only the URL from an Excel cell?
Right-click the linked cell and choose Copy Hyperlink. If that command is missing, open Edit Hyperlink or Edit Link, copy the text in the Address field, and close without saving changes.

How do I copy a link to an Excel file?
Save the workbook to OneDrive or SharePoint, select Share > Copy Link, and set the audience and permissions in the dialog. A local file path is not a reliable substitute for a shareable cloud link.

Can I link directly to a worksheet or cell?
Yes. Use Ctrl+K or Insert > Link, choose Place in This Document, select the worksheet, and specify a cell if needed. Copy the resulting internal hyperlink if you need to paste that target elsewhere.

Why can’t someone open the link I sent?
The recipient may not have permission, may be signed in with a different account, or may be using a link to a local file. Review the OneDrive or SharePoint sharing settings and provide access through an approved option.

Does copying a hyperlink change the original cell?
No. Choosing Copy Hyperlink copies its destination without changing the cell. Editing the address and confirming the edit dialog, however, changes the hyperlink in the workbook.

What is the shortcut for copying a link in Excel?
There is no universal keyboard shortcut that copies only a hyperlink target. Use the cell’s context-menu command or copy the Address field. On Windows, Ctrl+C and Ctrl+V copy and paste selected content; on Mac, use Command+C and Command+V.

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.