How to Remove Hyperlink in Excel: Step-by-Step Guide

Removing hyperlinks in Excel may seem daunting, but it’s quite a simple process. In just a few steps, you can remove any unwanted links from your spreadsheet. This quick guide will show you how to do just that.

Step by Step Tutorial on How to Remove Hyperlink in Excel

Before we get started, let’s understand what we’ll accomplish in the following steps. We’ll be removing hyperlinks from either a single cell, multiple cells, or even an entire spreadsheet.

Step 1: Select the Cell or Range

Firstly, click on the cell or range of cells that contain the hyperlinks you want to remove.

Selecting the cell or range is an essential step. If you want to remove a hyperlink from a single cell, click on that cell. For multiple cells, click and drag to select the range, or hold down the Ctrl key and click on each cell you want to clear.

Step 2: Right-Click and Choose ‘Remove Hyperlink’

After selecting, right-click on it and choose ‘Remove Hyperlink’ from the context menu.

By right-clicking, you open up a menu with several options. ‘Remove Hyperlink’ is usually toward the bottom of this menu. Clicking it will instantly remove the hyperlink from your selected cell or range.

After completing these steps, your selected cells will no longer contain hyperlinks. The text will remain as it was, but it will no longer be clickable.

Tips for Removing Hyperlinks in Excel

  • Always make sure you have selected the correct cells before removing hyperlinks to avoid any accidental data loss.
  • If you’re working with a large data set, use the ‘Find & Select’ feature to quickly locate all hyperlinks.
  • To remove all hyperlinks in a worksheet at once, you can use a simple VBA script.
  • Remember that removing a hyperlink does not undo any formatting changes that happened when the hyperlink was added.
  • If you only want to disable the hyperlink temporarily, you can simply change its text format.

Frequently Asked Questions

How do I remove multiple hyperlinks at once?

You can select multiple cells by holding down the Ctrl key and clicking on each cell, then right-click and choose ‘Remove Hyperlink’.

Is there a keyboard shortcut to remove hyperlinks in Excel?

No, there is not a direct keyboard shortcut. However, you can use the ‘Alt’ key to navigate the menus after right-clicking.

Can I undo the removal of a hyperlink?

Yes, you can undo the action by pressing Ctrl + Z or by clicking the undo button in the toolbar.

Will removing a hyperlink affect the data in the cell?

No, removing a hyperlink will not affect the data in the cell; it simply makes the text or data non-clickable.

How can I prevent hyperlinks from being automatically created in Excel?

You can turn off the automatic hyperlink feature by going to File > Options > Proofing > AutoCorrect Options and unchecking the ‘Internet and network paths with hyperlinks’ option.


  1. Select the cell or range with the hyperlink.
  2. Right-click and choose ‘Remove Hyperlink’.


Removing hyperlinks in Excel is a breeze once you know the steps. Whether you’re tidying up a spreadsheet or removing links that are no longer relevant, the process is straightforward. Just remember to select the right cells and right-click to find the ‘Remove Hyperlink’ option. With our tips and frequently asked questions, you’ll be a pro at managing hyperlinks in no time. And remember, while removing hyperlinks is a simple task, always double-check your selections to maintain the integrity of your data. Now go ahead, give it a try, and enjoy a hyperlink-free spreadsheet!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy