8
Mar 2010

Removing Hyperlinks in Excel

Tags: Excel, General
comment icon0 comment(s) |

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.

Subscribe to our Networks

IW on Facebook