If we have Hyperlink in single cell, we can do right click on cell and click “Remove Hyperlink” to remove


How can we handle, if we have Hyperlink in sheet more than 1000 records ?

Do following steps to remove hyperlink in one shot.


Option A

Select the Hyper-linked cells before you run following macro
Sub Macro()
End Sub

If you don’t know where to paste above macro.

a)Press Alt+F11 to open VB editor
b)Press Alt+I+M to open Madule
Then paste and press F5 to Run.
Option B
Select the Hyper-linked cells and copy. Paste special and value.

Hope you like this post