Remove a hyperlink while keeping the cell text

To delete a hyperlink in Excel, right-click the cell containing the link and select Remove Hyperlink from the menu. The text stays in the cell — only the clickable link disappears. This is the fastest way when you have one or two links to remove.

If you want to remove the text entirely, delete the cell content as you normally would. But most of the time you'll want to keep what's written there and just break the link, which is what the Remove Hyperlink command does.

Excel stores hyperlinks separately from the text you see on screen. When you remove a hyperlink, you're only removing the link layer — the visible text remains unchanged and unformatted.

Key Takeaways

  • Right-click any cell with a hyperlink and choose Remove Hyperlink to break the link while keeping the text.
  • The Remove Hyperlink option appears only when you right-click a cell that actually contains a hyperlink.
  • Deleted hyperlinks cannot be undone after you close the file, so save your work before removing many links at once.
  • If a cell shows a hyperlink but right-click doesn't show the Remove option, the formatting may be applied to text rather than the cell itself.

Remove a single hyperlink with the right-click menu

Click the cell containing the hyperlink you want to remove. The cell should show underlined blue text or text formatted as a link. Move your mouse over the cell and right-click (or control-click on Mac).

A menu will appear with several options. Look for Remove Hyperlink — it's usually near the top of the menu, sometimes grouped with other link options. Click it once. The hyperlink disappears when ready, but the text remains in the cell with normal formatting.

You can now click the cell without triggering the link. If you want to edit the text itself, double-click the cell to enter edit mode and make changes as you would with any other cell content.

Delete multiple hyperlinks at once

If you need to remove many hyperlinks from a range of cells, select all the cells at once rather than removing them one by one. Click the first cell, then hold Shift and click the last cell in the range you want to remove links from. All cells between them will be highlighted.

Right-click anywhere in the selected range and choose Remove Hyperlink. Excel removes the hyperlink from every selected cell in a single action. The text in all those cells stays intact.

This method works even if some cells in your selection don't contain hyperlinks — Excel only removes links from cells that have them and leaves other cells unchanged.

Use the Edit menu if right-click doesn't work

Some versions of Excel or some spreadsheet configurations don't show Remove Hyperlink in the right-click menu. If that happens, use the menu bar instead. Click the cell with the hyperlink, then go to Edit in the top menu and look for a Links option or Remove Hyperlink command.

On newer versions of Excel for Windows, the menu bar may be labeled differently — look for Home or Data tabs at the top. In Excel for Mac, the Edit menu is in the same location as other applications.

If you still don't see a Remove Hyperlink option, the text may have been formatted as a link through character formatting rather than as a true hyperlink. In that case, select the text and clear all formatting by pressing Ctrl+M (Windows) or Cmd+M (Mac).

Understand the difference between hyperlinks and formatted text

Excel distinguishes between a true hyperlink — a clickable link stored as link data — and text that straightforward looks like a link because it's been colored blue and underlined. The Remove Hyperlink command only works on true hyperlinks.

If someone manually formatted text to look like a link by changing its color and adding underline, you won't see a Remove Hyperlink option when you right-click. Instead, select the text and use the formatting toolbar to remove the underline and change the color back to black or your preferred text color.

True hyperlinks are created through the Insert menu (Insert > Hyperlink) or by pasting a URL into a cell. If you're unsure whether a cell contains a true hyperlink, right-click it — if Remove Hyperlink appears, it's a real hyperlink.

Recover a deleted hyperlink if you haven't closed the file

If you remove a hyperlink by mistake, press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready to undo the deletion. This works as long as you haven't closed and reopened the file. Each undo step takes you back one action, so you may need to press it multiple times if other changes happened after you removed the link.

Once you close the file without saving, the undo history is lost and you cannot recover the deleted hyperlink. If you realize the mistake after closing, you'll need to recreate the link manually through Insert > Hyperlink.

To avoid accidental deletions when removing many links, save your file with a different name first (File > Save As). That way you have a backup if something goes wrong.

Delete the entire cell if you want text and link gone

If you want to remove both the hyperlink and the text it contains, select the cell and press Delete. This clears all content from the cell, including the link and any text. The cell becomes empty.

If you want to delete the cell itself rather than just its contents — shifting other cells up or to the left — right-click the cell and choose Delete. A dialog will ask whether you want to shift cells up or left. Choose the direction that makes sense for your spreadsheet layout.

Clearing a cell's contents is different from deleting the cell. Clearing leaves the cell in place but empty. Deleting removes the cell and reorganizes the surrounding cells. Use whichever matches what you're trying to accomplish.

Frequently Asked Questions

Does removing a hyperlink change the text color back to black?

Usually yes. When you remove a hyperlink, Excel returns the text to normal formatting, which is typically black. However, if the text was manually formatted with a different color before the hyperlink was added, it may return to that color instead. Check the cell after removing the link to see what color it displays.

Can I remove hyperlinks from an entire column at once?

Yes. Click the column header to select the entire column, then right-click and choose Remove Hyperlink. Excel removes hyperlinks from every cell in that column while leaving all text intact. This is useful if a whole column contains links you no longer need.

What if the hyperlink points to a file that no longer exists?

The link still works as a hyperlink in Excel — it just won't open anything when clicked because the file is gone. Remove the hyperlink using the right-click menu if you don't want users to see a broken link. The text will remain in the cell.

Can I remove hyperlinks without opening the file in Excel?

No. You must open the file in Excel or another spreadsheet program to access the Remove Hyperlink command. Some online spreadsheet tools like Google Sheets have similar options, but you cannot remove hyperlinks from a closed file.

Why does my hyperlink keep coming back after I remove it?

This usually happens if the cell contains a formula that automatically creates hyperlinks, or if AutoCorrect is set to convert URLs into links. Check the formula bar to see if the cell contains a formula. If it does, edit the formula to stop creating the link. For AutoCorrect, go to File > Options > Proofing > AutoCorrect Options and uncheck "Internet and network paths with hyperlinks."