Skip to content
Related Articles

Related Articles

How to Remove Hyperlinks in Excel?

View Discussion
Improve Article
Save Article
  • Last Updated : 16 Dec, 2021

The HYPERLINK function generates a shortcut that opens a document saved on a server or the Internet, or moves to another position in the existing workbook. Excel moves to the specified URL or displays the file when you click a cell that includes a HYPERLINK function. The syntax for a hyperlink function is as follows:

Syntax:

HYPERLINK(link_location, [friendly_name])

Difference between clear hyperlinks and remove hyperlinks:

  1. Clear Hyperlinks: The hyperlinks in the selected cells will be deleted. The formatting will not be cleared. 
  2. Remove Hyperlinks: The hyperlinks and formatting in the chosen cells should be removed.

To Remove or Turn off Hyperlinks:

You can eliminate a single hyperlink, many hyperlinks in one go, disable automatic hyperlinks, and disable the need to use Ctrl to follow a hyperlink.

This article will provide you with different methods to remove the hyperlinks in Excel.

Method 1: Using the menu

To remove a hyperlink but keep the text, simply right-click on the cell which has the hyperlink and click the Remove Hyperlink option.

In conclusion, you can go through the procedures again and remove hyperlinks from additional cells. Furthermore, you may use this procedure to delete hyperlinks from both cells by selecting them together.

Method 2: Remove in the Edit Hyperlink Window

Follow the below steps to remove hyperlinks using Window

Step 1: Select the target cell with the right mouse button.

Step 2: Then select “Edit Hyperlink” from the drop-down menu.

Step 3: Press the “Remove Link” button in the “Edit Hyperlink” window. Keep in mind that the hyperlink in the “Address” text box should not be cleared. Otherwise, the “OK” button will be inactive.

The popup will vanish as soon as you click the “Remove Link” button. In addition, the cell’s hyperlink has been erased. Unlike the previous way, you cannot delete the hyperlinks for various cells at the same time. To totally remove the hyperlink, select it and then press the Delete key.

Method 3: Remove from the Toolbar

Follow the below steps to remove hyperlinks from the Toolbar:

Step 1: Choose the desired cell. To pick a cell, use the arrow keys on your keyboard or click and hold the mouse button.

Step 2: Next, on the toolbar, click the “Clear” button.

Step 3: Then there are 2 choices related to hyperlinks in the drop-down menu.

Step 4: The hyperlink will be erased from the cell if you select “Clear Hyperlinks” from the menu. The format, though, will not change. A little button will also be shown close to the actual cell. When you click the button, a menu with two alternatives appears. You get to choose whether or not to exit the format at this point.

Step 5: The hyperlink will be deleted asap if you select “Remove Hyperlinks” from the menu.

Simultaneously, the format will be phased out. The distinction between the two options beneath the “Clear” button is this. When you save the cell format, you can use this approach to select “Clear Hyperlinks.” You can even remove hyperlinks for several cells at once with this method. If you choose to leave the format alone, the formatting of all the cells will remain unchanged.

Method 4:  Using HYPERLINK function

If you used the HYPERLINK function to establish the hyperlink, you can remove it by following these steps:

Step 1: Choose the cell that contains the hyperlink.

Step 2: To copy the hyperlink, use CTRL+C.

Step 3: By using the Values paste option, right-click and paste.

Method 5(Excel 10 and above): To remove all hyperlinks at the same time

Follow the below steps to remove all hyperlinks at the same time in Excel 10 or ge=reater versions:

Step 1: Click all cells with hyperlinks or select all cells by using Ctrl+A.

Step 2: Remove Hyperlinks by right-clicking and selecting Remove Hyperlinks.

We will advise you to be patient with Excel as it may glitch sometimes and not give you the desired output right away. It is good if you just close the window and reopen it.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!