Sunday, November 13, 2011

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()
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

Twitter Bird Gadget