To remove a hyperlink in Excel for Microsoft 365 on Windows, right-click the linked cell and choose Remove Hyperlink. To stop Excel automatically turning URLs into links, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and clear Internet and network paths with hyperlinks.
What “no hyperlink” can mean in Excel
A cell that looks like a web address is not necessarily an active link. It might be plain text, a hyperlink inserted into the cell, or the result of a formula that creates a link. The right fix depends on which kind you have. A blue, underlined address is often a hyperlink, but formatting alone does not prove that it is one.
To check, select the cell and look at the formula bar. A normal address such as https://example.com may be plain text or an inserted hyperlink. A formula beginning with =HYPERLINK( is a formula-generated link. You can also right-click the cell: if the menu offers Remove Hyperlink or Edit Hyperlink, Excel recognizes a hyperlink there. Hovering over an active link may show its destination.
These distinctions matter when you want the visible words to remain but do not want a click to open a website, file, email address, or another cell. Removing a link is different from deleting the cell’s contents, and disabling automatic links affects future entries rather than links already in the workbook.
Remove one hyperlink while keeping its text
For a regular hyperlink in a worksheet, right-click the cell and select Remove Hyperlink. The linked text stays in the cell as ordinary content, but clicking it no longer follows the destination. This is usually the simplest choice when you are cleaning up one cell and want to retain its label or address.
You can also select the cell and use the ribbon command Home > Clear > Remove Hyperlinks. This is useful if you prefer ribbon commands or if the right-click menu is difficult to use. The command removes the link, not the worksheet row, column, or surrounding data.
- To undo immediately after creating or removing a link, press Ctrl+Z on Windows.
- On a Mac, use Command+Z to undo. Right-clicking may require a two-finger click or Control-click, depending on the mouse or trackpad settings.
- If the cell contains a formula-generated link, use the formula-specific method described below; the ordinary remove command may not turn the formula result into plain text.
Remove hyperlinks from a range or worksheet
To remove links from several cells at once, select the range and choose Home > Clear > Remove Hyperlinks. For example, if a list of supplier names in B2:B80 has been linked to web pages, select B2:B80 and apply the command. The names remain in their cells, while their hyperlinks are removed.
You can select nonadjacent cells by holding Ctrl while clicking each cell on Windows, then use the same ribbon command. On a Mac, use Command while selecting separate cells. To select a whole worksheet, click the triangle at the top-left corner between the row numbers and column letters, but consider whether the sheet contains links you actually need before applying the command.
After a bulk removal, spot-check a few cells by right-clicking them or trying the link. If the text is still blue and underlined, that appearance may be formatting left behind or applied separately; it does not always mean the link is still active. Avoid using Home > Clear > Clear All as a shortcut: it clears cell contents and formatting as well as other cell properties, which can damage the sheet.
Stop Excel from creating links automatically
Excel for Microsoft 365 on Windows can automatically turn typed internet and network addresses into hyperlinks. To disable that behavior, open File > Options > Proofing > AutoCorrect Options, choose the AutoFormat As You Type tab, and clear Internet and network paths with hyperlinks. Select OK to save the setting. This affects automatic linking as you type; it does not remove links already present in existing cells.
For a one-time correction, press Ctrl+Z immediately after Excel converts the address. In many cases this reverses the automatic hyperlink while leaving the typed text. If you see an AutoCorrect Options button or icon near the edited cell, its menu may offer an option to stop automatically creating hyperlinks. Undo is the more straightforward choice when you only want to cancel the most recent conversion.
On Mac, Excel’s settings are under the Excel menu rather than the Windows File menu. Depending on the current Mac release, open Excel > Settings or Excel > Preferences, then find AutoCorrect and its AutoFormat As You Type options. Clear the option for internet and network paths with hyperlinks if it is available. Excel for the web does not expose the same desktop AutoCorrect settings, so use Undo after automatic conversion or remove a link from the cell instead.
Handle links made with the HYPERLINK formula
A cell can display friendly text while a formula supplies the destination. For example, with no particular cell layout required, this formula displays the words Open report and links them to the example address: =HYPERLINK("https://example.com","Open report"). The formula itself is the reason the result behaves as a link, so removing an inserted hyperlink is not the same as removing this formula.
If you want to keep the displayed result but make it static text, copy the formula cell and replace it with its value using Home > Paste > Values. Check the result before deleting anything: the cell should show the intended label, and the formula bar should no longer show a HYPERLINK formula. This replacement removes the formula’s ability to generate a link, but it also means later changes to the formula’s inputs will not update the label.
If you only want a different destination or label, edit the formula rather than converting it. In a formula, the first argument is the link location and the optional second argument is the text Excel displays. Make sure the destination is correct before sharing the workbook, especially if it points to a local file path that other people may not be able to access.
Keep the text, formatting, and destination straight
A hyperlink has a visible label and a destination, and those are not always identical. A cell might display “Quarterly report” but open a long web address, a file, an email message, or another location in the workbook. Removing the link keeps the cell’s content in ordinary cases, but it does not mean that the displayed words were the destination in the first place.
Likewise, blue underlined text can be produced by formatting without any hyperlink. If the right-click menu does not offer a hyperlink command, the cell may simply use a font color and underline. You can change that appearance from the Home tab’s font controls without changing the cell’s text. Conversely, a hyperlink may have been given a custom color that makes it look like normal text, so test the cell rather than relying only on its appearance.
When you want to preserve the exact visible content, avoid deleting the cell or using Clear All. For a normal inserted link, use Remove Hyperlink. For a HYPERLINK formula, paste values if a fixed text result is acceptable. If the original formula’s result may change, keep a copy of the formula or workbook before replacing it.
Common problems and practical checks
- The link seems to remain: Check whether the cell uses a HYPERLINK formula. If it does, convert the formula result to a value or revise the formula.
- The text is still blue and underlined: Test whether it opens anything. If it does not, adjust its font formatting separately. If it does, remove the active hyperlink.
- Only some addresses become links: Check whether the addresses were pasted from another source, generated by formulas, or entered before the AutoCorrect setting was changed. The setting does not retroactively affect old cells.
- A link opens the wrong place: Use Edit Hyperlink from the cell’s context menu to inspect or change the destination instead of deleting the link if it is still needed.
- A file link works only on one computer: The destination may be a local or network path unavailable to other users. A link is not a copy of the linked file; share the file in an accessible location and update the destination if collaborators need it.
For a workbook with many sheets, check whether links occur in worksheet cells, shapes, or other objects. Selecting a cell range only addresses links in that range; it does not automatically remove every kind of link in the entire workbook. Save a separate copy before a large cleanup if the workbook is important, so you can compare results or restore the original.
Frequently Asked Questions
How do I remove a hyperlink in Excel but keep the text?
Right-click the linked cell and choose Remove Hyperlink. For several cells, select the range and use Home > Clear > Remove Hyperlinks. The cell text remains.
How do I stop Excel from automatically making URLs clickable?
In Excel for Windows, clear Internet and network paths with hyperlinks under File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type. This setting applies to future typing, not existing links.
Can I remove hyperlinks from an entire Excel sheet at once?
Select the worksheet cells, then choose Home > Clear > Remove Hyperlinks. Review the sheet first, because this removes useful links too. It does not necessarily cover links stored in shapes or other objects.
Why does a cell still look like a hyperlink after I remove it?
The blue font and underline may remain as formatting, or they may have been applied manually. Test the cell or check its context menu. If it is no longer clickable, change the font formatting separately rather than clearing all cell contents.
Why can’t I remove a HYPERLINK formula like a normal link?
The formula generates the clickable result. Copy the cell and use Home > Paste > Values to keep a fixed version of the displayed text, or edit the formula if you still need a link with a different destination.
Related
- How to Partially Protect an Excel Sheet
- How to Print Just a Highlighted Area in Excel
- How to Merge Cells in Excel Without Losing Data Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Compare Two Excel Sheets and Find DifferencesTo compare two Excel sheets cell by cell, put a formula on a third sheet such as =IF(Sheet1!A1=Sheet2!A1,"Same","Different"),…
- To Do List Sample Excel: Create a Practical Task TrackerA useful to-do list sample in Excel has columns for the task, owner, due date, priority, status, and…
- Excel Find and Replace in Selected CellsYes. In Excel for Microsoft 365 on Windows, select a multi-cell range, press Ctrl+H, enter the text to…
- Keyboard Shortcut to Insert a Checkbox in Microsoft WordIn Word for Microsoft 365 on Windows, type 2610 and press Alt+X to insert an empty checkbox symbol…
- Excel Dropdown List Default Value: Set a Starting ChoiceExcel’s Data Validation dropdown has no built-in setting that automatically selects a default value. To show a starting…
- How to Highlight Just One Word in an Excel Cell ManuallyTo highlight just one word in an Excel cell, edit the cell, select only that word, then use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.