Removing Hyperlinks in Excel

Removing Hyperlinks in Excel

//

Excel and myself, we don’t get a long very well. Excel, for some reason thinks it’s really cool and neat that it can make anything that looks like a URL or email address clickable and making the text blue with a nice underline as an extra touch. I’m not particular fond of this. However, it’s fairly obvious how to remove these: Right click and select “Remove Hyperlink”

 

But what if you have a document with a ton of these pesky buggers? Right click each one individually? Yeah, NO!

Here is my solution to get rid of these things:

1. Press ALT + F11

2. On the left, double click your worksheet or workbook and copy and past the following:

Sub RemoveHyperlinks()
    ActiveSheet.Hyperlinks.Delete
End Sub

3. Click save.

4. Go back to your spreadsheet and press ALT + F8, select your macro, and then click the Run button.

 

Hyperlinks are gone.

SIGMA RAPID START

Switching your analytics to Sigma?
Speed up success with a Rapid Start!