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:
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.