How to Remove Linking in Excel

What this does

Removing a hyperlink deletes the link target from a cell while leaving the text you see. Excel has two commands for it: Remove Hyperlink on the right-click menu for the selected cells, and Home ▸ Clear with Remove Hyperlinks (link and link formatting) or Clear Hyperlinks (link only). Links built with the HYPERLINK function are different — they are formulas, so the commands above do not touch them; you replace the formula with its value instead. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “remove linking in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a data step that keeps your analysis trustworthy into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Column B holds 40 pasted web addresses, all clickable. Select B2:B41, then Home ▸ Clear ▸ Remove Hyperlinks: every address is still there as plain text, none opens a browser, and the blue underline is gone. A cell that shows "Go to Summary" from =HYPERLINK("#Summary!A1","Go to Summary") keeps working until you copy it and use Paste Values, which leaves the text "Go to Summary" without a link. Pasted lists of addresses, emails and file paths arrive as clickable links that open a browser on every stray click. Removing the link while keeping the text makes the column safe to edit, sort and export. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Here is the takeaway for “remove linking in excel”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.

Common mistakes

• Pressing Delete, which removes the text along with the link — Remove Hyperlink keeps the text.
• Expecting Remove Hyperlink to affect HYPERLINK() formulas; they must be converted to values.
• Clearing the link but not the AutoCorrect option, so the next typed web address becomes a link again.
• Confusing cell hyperlinks with links to other workbooks — those are managed from Data ▸ Edit Links, not from the Clear menu.

Frequently asked questions