Excel Guides

How to Get Rid of All Hyperlinks in Excel

If you want to get rid of all hyperlinks in an Excel sheet, there are a few ways you can do this. One way is to use the Find and Replace feature. Go to the Home tab, click on Find & Select in the Editing group, and then click on Replace. In the Find what field, type in "^p" (without the quotation marks) and leave the Replace with field blank. Then click on the Replace All button. This will remove all hyperlinks from your sheet.

Another way to remove hyperlinks is to use a macro. The following macro will remove all hyperlinks from your active sheet:

Sub RemoveHyperlinks()
    Dim i As Long

    For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
        ActiveSheet.Hyperlinks(i).Delete
    Next i
End Sub

To use this macro, open the Visual Basic Editor (press Alt+F11), insert a new module (Insert > Module), and paste the code into the module. Then close the Visual Basic Editor and run the macro by pressing Alt+F8 and selecting RemoveHyperlinks from the list of macros.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.