How To: Remove all hyperlinks on a sheet in Excel 97/2000/2003/XP

Are you doing a copy/paste of content from web to your excel sheet and hyperlinks also get copied along but would you want to avoid or remove the links from the excel sheet without editing each and every cell? Here is a mini tutorial on creating a macro in excel that will help you accomplish task of removing all the hyperlinks with ease. It’s very easy.

Note: This excel tip will remove all the hyperlinks from the currently active worksheet only.

Step1: While the excel document is open, press [ALT]+[F11]. This combination of keys will open the visual basic editor where you will create a macro to remove the hyperlinks.

Step2: Click on “Insert” from the menu on the top, then click on the sub menu called “Module”. You would now see a window opening on the right hand side of the editor window.

Step3: In this window, copy and paste the below mentioned code.

Sub RemoveLinks()
‘Remove all hyperlinks from the currently active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

Step4: Now click on “File” menu item, select “Close and return to Microsoft Excel”. The visual basic editor window will close and you will return to Microsoft excel document window.

Assuming that you have the sheet, that has hyperlinks that you want to automatically remove, is open, you will run the Macro “RemoveLinks” which we created using the steps mentioned above.

To run the macro, click on Tools -> Macro -> Macros and select “RemoveLinks” from the list of Macros and click on Run button. That’s it. The macro will scan through the sheet and remove all the hyperlinks. You can also open the Macros screen by pressing [ALT]+[F8].

This macro saved a lot of my time which I would have otherwise wasted removing hyperlinks from each and every cell in the excel sheet. I hope this will save a lot of your time too going forward.

Tags: Excel Tips, Excel Macro, MS Office Tips