Home » » How to remove all hyperlinks in excel in a single step

How to remove all hyperlinks in excel in a single step

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

0 comments:

Post a Comment

Like us on Facebook
Follow us on Twitter
Recommend us on Google Plus