How to Change a Link Name in Excel

How-to basics · Updated November 20, 2026

To change the name people see for a hyperlink in Excel for Microsoft 365 on Windows, right-click its cell, choose Edit Hyperlink, change Text to display, and select OK. This changes the visible label, not the web address or file path the link opens. If the link comes from a formula, edit the formula’s friendly-name argument instead.

A link name, also called display text or friendly text, is the clickable wording shown in a worksheet. For example, you can change a long address into “Open the project plan” without changing where the link leads. The steps below cover ordinary hyperlinks, formula-created links, and practical checks to confirm the result.

What You’ll Need

  • An Excel workbook containing the hyperlink you want to rename. If the workbook is read-only or protected, you may need permission to edit it.
  • The correct destination address, if you also intend to change where the link goes. Renaming the label alone does not alter the destination.
  • Excel for Microsoft 365 on Windows for the main instructions. Excel for Mac and Excel for the web have similar options, with some differences noted below.

Step-by-Step

  1. Find and select the hyperlink. Open the worksheet and locate the cell containing the link. Click the cell once to select it; avoid double-clicking, which can put the cell into edit mode. If you are unsure which cell holds a link, look for the usual blue, underlined text or hover over it to see a destination preview. The style may have been changed, so appearance alone is not always a reliable test.
  2. Open the link editor. Right-click the cell and choose Edit Hyperlink from the context menu. In some Excel builds, the command may be called Edit Link. The Insert Hyperlink dialog opens with the current label and destination. If you see Open Hyperlink instead, make sure you right-clicked the cell rather than clicking the link itself. You can also select the cell and use Insert > Link on the ribbon; look for the option to edit the existing link.
  3. Replace the displayed name. In the dialog, find the Text to display box. Select its current contents and type the new label, such as “View the meeting notes.” Keep the label short enough to fit the column, but make it descriptive enough that someone reading the workbook can tell what will open. Do not type the replacement into the Address box unless you mean to change the destination.
  4. Keep or update the destination deliberately. Check the Address field before you finish. If you only want a different name, leave the address unchanged. If the link should point somewhere else as well, enter the correct web address or file path in that field. For a web link, include the full address, such as https://example.com/report. For a file link, verify the path points to the intended file and that its location will be accessible to the people using the workbook.
  5. Save the change. Select OK in the dialog. The cell should now show the new label while remaining clickable. Save the workbook with Ctrl+S on Windows. On a Mac, use Command+S. If the workbook is stored in OneDrive or SharePoint with AutoSave enabled, still check that the save indicator has finished before closing it.
  6. Verify what the link opens. Hover over the renamed link or reopen Edit Hyperlink to check its destination. When you are ready to test it, follow the link using the method appropriate to your Excel version; depending on settings, you may need to hold Ctrl while clicking in Windows. On Mac, the click behavior can depend on Excel preferences. Test links to important files or business resources, and avoid opening a destination you do not recognize.
  7. Adjust the cell if the new label is hard to read. A longer display name may be cut off by the next populated cell. Widen the column by dragging its right boundary, or use Home > Format > AutoFit Column Width. You can also wrap text, but a row may become taller. Formatting changes are optional: they do not change the hyperlink destination or its label.

For a HYPERLINK formula: The cell’s displayed name may be generated by a formula rather than by the dialog. Select the cell and inspect the formula bar. If it contains a HYPERLINK formula, edit the formula’s second, optional argument, which supplies the friendly name. With a URL in A2 and the formula in B2, use =HYPERLINK(A2,"Open the project plan"). The cell will display “Open the project plan” and link to the address stored in A2. If A2 contains https://example.com/plan, that is the destination; changing only the quoted text changes only the label. Preserve the formula’s parentheses and quotation marks when editing it.

Common Mistakes

  • Changing the destination instead of the label. The Text to display and Address fields serve different purposes. If the name changes but the link opens the wrong place, reopen the editor and check both fields.
  • Typing over the cell contents. Selecting a hyperlink cell and typing a new name directly can replace the cell’s contents and remove the link. Use Edit Hyperlink for a standard link, or edit the friendly-name argument if the link is created by a formula.
  • Trying to edit a formula-driven link in the dialog. When a cell contains a HYPERLINK formula, Excel calculates its displayed text from that formula. Changing the formula is the right way to change the label; replacing it with plain text discards the formula and may remove the link.
  • Using a vague label. Names such as “Click here” or “Link” are hard to distinguish, particularly in a long list. Prefer labels that identify the destination or purpose, such as “Open the 2026 schedule.”
  • Assuming a renamed link is automatically safe or current. A convincing label does not prove that a web address or file path is correct. Check the destination, especially if the workbook came from someone else or the link points to a shared file.

Tips

  • Use consistent naming. If a worksheet has many links, use a repeatable pattern such as “View: [document name]” or “Open: [team or topic].” Consistent labels make a list easier to scan and maintain.
  • Make labels understandable out of context. A link may be copied, printed, or read with assistive technology. “Download the product guide” is more informative than “Here,” and is still concise.
  • Check the link’s scope before sharing. A path to a file on your computer may work only for you. For a shared workbook, use a destination that collaborators can access, such as an approved shared folder or a properly shared cloud link.
  • Keep a destination list for important links. If a workbook contains many links, record the purpose and destination in nearby columns or a maintenance sheet. That makes it easier to review links later without relying on their display names.
  • Use the formula bar to identify link types. A standard hyperlink usually has a stored display label, while a formula-driven link shows a formula beginning with an equals sign. Knowing which kind you have prevents edits that accidentally remove the link.
  • Make a copy before large changes. For a handful of links, editing them individually is straightforward. If you are changing many links, save a separate copy first and verify a sample of the updated labels and destinations before sharing the workbook.

Troubleshooting

You cannot find Edit Hyperlink. Confirm that you right-clicked the cell containing the link. If the cell is selected but the command is missing, try Insert > Link on the ribbon, or check whether the worksheet is protected. A protected sheet may prevent edits; ask the workbook owner for permission or have them unprotect it if appropriate. In Excel for the web, right-click the linked cell and look for the link-editing command; some options may be presented in a simpler panel than in desktop Excel.

The text changes back after you edit it. Check the formula bar. If the cell contains a HYPERLINK formula, the formula controls the displayed label. Change its friendly-name argument rather than typing over the cell. If the cell is part of a table or another process that refreshes its contents, check whether that process is restoring the old value.

The label changed, but the link does not work. Reopen Edit Hyperlink and inspect the address. Check for a missing character, an outdated page, or a file path that no longer exists. For links to local or network files, confirm that the file is still available to your account and that collaborators have access. A correctly named link can still have an invalid destination.

The new label is not fully visible. Widen the column, use AutoFit, or shorten the wording. If the cell is merged, wrapped, or constrained by a fixed layout, the label may remain clipped even when the text is correct. You can also use a nearby cell for additional explanation while keeping the clickable label concise.

The link opens when you meant only to edit it. Use the cell’s context menu rather than clicking the linked text. If a click opens a browser or file, close it and return to Excel; opening the destination does not normally rename or remove the link. Then right-click the cell and choose the edit command.

Frequently Asked Questions

Can I change a link’s name without changing its URL?
Yes. In the standard hyperlink dialog, change Text to display and leave Address alone. For a HYPERLINK formula, change only the friendly-name argument and preserve the link location.

Does changing the name change the underlying website or file?
No. The visible label and the destination are separate. The destination changes only if you edit the address field or alter the link-location part of a formula.

Why is Text to display unavailable or why does the label keep returning?
The cell may contain a formula, be locked on a protected worksheet, or be controlled by a process that refreshes its contents. Inspect the formula bar first; if there is a HYPERLINK formula, change its friendly-name argument. If editing is blocked, check sheet protection or contact the workbook owner.

Can I rename several hyperlinks at once?
Excel’s regular hyperlink dialog edits one link at a time. You can repeat the steps for each cell. For formula-driven links, update the formulas carefully and check that each one still points to the intended destination; do not use a broad replace operation without reviewing what it will change.

Do these steps work in Excel for Mac and Excel for the web?
The basic idea is the same: edit the link’s displayed text while keeping its destination unchanged. On Mac, use the cell’s context menu or Insert > Link; use Command+S to save. Excel for the web offers link editing from the cell’s context menu, though dialog wording and available controls can differ from Windows desktop Excel.

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.