How to Remove All Hyperlinks in Excel 2016 Document

remove all hyperlinks

Sometimes, in meetings or at work, many people add links to the Excel worksheet for convenience, allowing a click of the mouse to access the page they want to access. But if you don’t want these hyperlinks in the excel table for some reason, you can delete them all at once.

There are many ways to cancel hyperlinks in an excel table. It is very simple to delete only one hyperlink or more, just place the mouse over the hyperlink, and then right-click the mouse button and select “Remove Hyperlinks“. But if there are a lot of hyperlinks in the Excel worksheet, how do we cancel it? If you cancel each one manually, it would be a waste of time. What is the best way to cancel these hyperlinks at once? Here’s how tocancel all hyperlinks in the Excel worksheet.

Method 1: Remove all hyperlinks in Excel 2016 document by choosing all cells

Open the Excel 2016 document you would like to remove hyperlinks inside. Select all the cells from which you want to remove hyperlinks by pressing Ctrl + A on your keyboard. Then right-click the mouse button to choose Remove Hyperlinks. Then all existing hyperlinks in the Excel 2016 document can be canceled immediately.

choose remove hyperlinks

Method 2: Remove all hyperlinks from Excel 2016 document through Macro

Step 1: Open the Excel 2016 document with hyperlinks. Click View > Macros > Record Macro…

open record macro

Step 2: Enter the name of the macro (delete), and click OK.

input delete

Step 3: Click Macros > View Macros > choose delete > Edit.

choose edit button

Step 4: When the macro editor pops up, enter the corresponding codes are as follow:

Sub delete()

Cells.Hyperlinks.Delete

End Sub

enter the corresponding codes

Note: The first and third lines are built-in invariants. Change the middle content to “Cells.Hyperlinks.Delete” above, and then close the editor.

Step 5: Click Macros > View Macros > Run. And then you’ll see that the cell with the hyperlink changes from blue to black.

click run button

Method 3: Remove hyperlinks in Excel 2016 document by using Paste Special

Step 1: Select all cells that need to be unlinked, and right click the mouse button > choose Copy.

copy all cells with hyperlink

Step 2: Select any blank cell, right-click the mouse button, and select “Paste Special…“.

select paste special

Step 3: In the pop-up dialog box, select “values” and click OK.

choose value

Step 4: Delete the original cells with the hyperlink. And then the hyperlinks appear from the Excel worksheet at once.

delete the original cells

You May Also Like

About the Author: Darren

Leave a Reply

Your email address will not be published. Required fields are marked *