How to Delete a Link in Excel: A Practical How-To
Learn how to delete a link in Excel—remove hyperlinks from cells, break external references, and convert linked text to plain values with practical, step-by-step guidance.
Learn how to delete a link in Excel quickly. This guide covers removing hyperlinks from cells, breaking external data links, and turning linked text into plain values. Use simple right-click options or paste-as-values to clean your workbook without losing your data. By the end, your sheet will be free of unwanted links.
What delete link in excel really means
In the context of Excel, a "link" usually means a hyperlink in a cell or a data connection that points to an external source. A hyperlink is a clickable URL or reference that opens a web page or document. A link can also be embedded in a formula (for example, the HYPERLINK function) or come from an external data source. When you set out to delete a link, you are typically trying to do one of two things: remove the clickable behavior while preserving the displayed text, or remove the external reference entirely so the workbook no longer relies on it. Understanding the distinction helps you choose the right method and avoid accidental data loss. This section clarifies common link types and why you might want to delete them in everyday Excel workflows.
Pro tip: Start by identifying all link types in your workbook so you can tailor your approach rather than applying a blanket method that might affect formulas or data connections.
Quick checks before removing links
Before you start deleting links in Excel, run a quick audit to prevent unintended consequences. First, determine whether a link is a simple clickable hyperlink or part of a formula like HYPERLINK(). Check a few cells by hovering to see the URL or parsing the formula bar to spot a HYPERLINK() function. Next, scan for external data connections or workbook links under the Data tab (Edit Links in many versions) to catch links that reference other workbooks. If your workbook feeds data from external sources, breaking those links could replace live data with static values, so always work on a copy. Finally, consider whether the link is used by conditional formatting rules or data validation that relies on a URL or address. Knowing these dependencies helps you avoid surprises after cleanup.
Remove a hyperlink from a single cell
To delete a hyperlink from a single cell while keeping the display text, right-click the cell and choose Remove Hyperlink (or use the equivalent command on Mac). The cell text remains visible, but the clickable URL is removed. If the text itself is the URL (for example, http://example.com), you may want to replace it with a friendly display text first and then remove the hyperlink. After removing, press F2 to edit if you want to adjust the display text. This method is quick and low-risk for isolated cleanup tasks in your sheet.
Remove hyperlinks from a range or entire sheet
When multiple cells contain hyperlinks, you can remove them in bulk. Select the range (or the entire sheet with Ctrl+A), then right-click and choose Remove Hyperlink, or use the Clear Hyperlinks option if your version supports it. If your workbook uses a mix of text and hyperlinks, consider first converting text to values (paste Special > Values) to strip the hyperlink formatting from all affected cells. Bulk removal is efficient but make sure you don’t erase non-link formatting you want to keep.
Tip: For large ranges, you can also use a short macro to strip hyperlinks in one go, which saves time across many worksheets.
Handling hyperlinks created by the HYPERLINK function
Hyperlinks created by the HYPERLINK function (e.g., HYPERLINK("https://example.com", "Visit site")) behave differently from simple hyperlinks. To delete these, remove or replace the HYPERLINK formula with plain text or a value. If you want to preserve the display text, copy the cells and paste values over them. This converts formulas to static text, removing the link while keeping the visible label. Be mindful that removing the function may alter the intended behavior of your sheet if the link was part of a dynamic calculation.
Break external links to other workbooks or data sources
External links can connect your workbook to other files or data sources. In many Excel versions, you can manage these from the Data tab by selecting Edit Links and choosing Break Link. This operation converts linked formulas and data references into their current values, effectively removing the dependency on the external source. Always confirm that the resulting values are acceptable and consider saving a backup with the links intact before breaking them. If the workbook contains data queries, you may need to refresh or adjust connections after breaking links.
Clean-up steps: converting to values and preserving text
After deleting links, you may want to ensure the remaining content is stable. Copy a range with links and use Paste Special > Values to convert formulas or linked text into static values. This preserves the visible content while disabling any link behavior. Review conditional formatting rules, data validation, and formulas that might reference the deleted URLs or external references. Saving a clean version of the workbook minimizes future issues and makes sharing safer for collaborators.
Best practices and common pitfalls
- Always work on a backup copy before removing links.
- Distinguish between hyperlinks and HYPERLINK formulas to choose the right method.
- When in doubt, convert to values to avoid breaking formulas that depend on external data.
- After cleanup, verify critical references and refresh data connections if needed.
- If the workbook contains macros, ensure they do not re-create links on the next run.
Common mistakes include deleting display text unintentionally, breaking essential data connections, and failing to update dependent calculations after breaking links. By testing changes on a copy and validating important outputs, you minimize these risks.
Tools & Materials
- Microsoft Excel (Windows or macOS)(Use a recent version with standard hyperlink management features.)
- Active workbook with hyperlinks(The file you plan to clean up.)
- Backup copy of your workbook(Create a separate file before making changes.)
- Access to the Data tab (for breaking external links)(Helpful when you need to break links to other workbooks.)
- Basic understanding of formulas (HYPERLINK, INDIRECT, etc.)(Assists in identifying complex hyperlink scenarios.)
Steps
Estimated time: 15-25 minutes
- 1
Open the workbook
Launch Excel and open the file that contains the links you aim to delete. This initial step sets the context for the cleanup and ensures you are in the correct environment.
Tip: Keep a backup closed until you finish the cleanup to avoid accidental data loss. - 2
Identify the link type
Hover or inspect the formula bar to determine whether the link is a simple hyperlink, a HYPERLINK function, or part of an external data connection. This helps you choose the right removal method.
Tip: If the URL is embedded in a formula, you’ll need to address the formula itself, not just the displayed text. - 3
Remove a hyperlink from a single cell
Right-click the cell and select Remove Hyperlink to delete the clickable URL while preserving the displayed text. If the text is the URL itself, replace it with friendly text first, then remove the hyperlink.
Tip: For Mac users, the option may appear in a slightly different menu path; look for the same Remove Hyperlink action. - 4
Remove hyperlinks from a range or sheet
Select the range or entire sheet, right-click, and choose Remove Hyperlink. Alternatively, use Copy > Paste Special > Values to strip links by converting to static text.
Tip: Bulk removal is faster, but verify that no non-link text is affected in the process. - 5
Handle HYPERLINK formulas
If hyperlinks are created with the HYPERLINK function, delete or replace the function with plain text or a value to remove the link while keeping visible labels.
Tip: Copy and paste as values after deleting the function to finalize the cleanup. - 6
Break external workbook links
Go to Data > Edit Links (or the equivalent in your version) and choose Break Link. Confirm prompts to remove the connection and convert linked data to its current static value.
Tip: Perform this on a copy first to validate that the resulting data is acceptable. - 7
Verify and adjust formulas
Check formulas that previously referenced external sources or hyperlink results to ensure they still produce the intended results after removal.
Tip: Use Find or Go To Special to quickly locate potential remnants of links. - 8
Save a clean version
Save the workbook under a new name to preserve the original while you validate that all links have been removed and that data integrity remains intact.
Tip: Document what was removed for future audits and collaboration.
People Also Ask
What is the difference between removing a hyperlink and breaking a link in Excel?
Removing a hyperlink deletes the clickable URL but keeps the visible text. Breaking a link removes the connection to an external source, which can affect formulas and data that rely on that source.
Removing a hyperlink keeps the text but disables the click. Breaking a link disconnects from an external source and may change calculated results.
How can I remove all hyperlinks in a workbook at once?
There isn't a universal single-click button in all versions. You can use a macro or copy and paste as values to strip links from the entire workbook.
There isn’t one built-in button for all versions; you can use a short macro or paste as values to remove everything at once.
Does removing hyperlinks affect the displayed text in cells?
Removing the hyperlink generally leaves the displayed text intact, unless the text itself was the URL. In that case, you may replace it with friendlier text.
Usually the text stays, but if the text is the URL, you’ll need to replace it with something readable afterward.
Is breaking external links safe?
Breaking external links converts dynamic references to static values. The data remains visible, but future updates from the external source won’t be reflected.
Yes, it’s generally safe, but you lose live connections to external data, so outcomes won’t update automatically.
What if my link is created by the HYPERLINK function?
Delete or replace the HYPERLINK function with plain text or a value to remove the clickable link while keeping the display text intact.
If the link comes from HYPERLINK, remove the function or replace it with plain text.
Are there differences between Windows and Mac Excel for deleting links?
The core steps are the same, but menu names and paths may vary slightly between Windows and macOS versions.
Mostly the same steps, with minor menu differences between Windows and Mac.
Watch Video
The Essentials
- Identify link types before removal.
- Use targeted removal for single cells and bulk removal for ranges.
- Convert to values to preserve data without links.
- Always back up before breaking external links.
