How to remove hyperlink in excel in one shot?

May be you have using this macro already.

Option A


Select the Hyper-linked cells before you run following macro


Sub Macro()
    Selection.Hyperlinks.Delete
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