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

18 Comments

  1. Howdy! This is kind of off topic but I need some advice from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about making my own but I’m not sure where to start. Do you have any points or suggestions? Thanks|

  2. Hi there just wanted to give you a brief heads up and let you know a few of the pictures aren’t loading properly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same outcome.|

  3. This design is wicked! You certainly know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job. I really loved what you had to say, and more than that, how you presented it. Too cool!|

  4. I do not know if it’s just me or if perhaps everybody else encountering issues with your blog. It appears as though some of the written text in your content are running off the screen. Can someone else please comment and let me know if this is happening to them too? This might be a issue with my internet browser because I’ve had this happen before. Cheers|

  5. I was curious if you ever thought of changing the structure of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two images. Maybe you could space it out better?|

  6. Howdy! I realize this is sort of off-topic however I had to ask. Does building a well-established blog like yours require a massive amount work? I am brand new to running a blog but I do write in my journal daily. I’d like to start a blog so I will be able to share my personal experience and feelings online. Please let me know if you have any ideas or tips for new aspiring bloggers. Appreciate it!|

Leave a Reply

Your email address will not be published.