How To Remove All Hyperlinks In Excel

How To Remove All Hyperlinks In Excel 2003 At Once

If you want to remove all hyperlinks in a worksheet at once, you can follow this tips:

  1. Select all worksheet. Shortcuts: Ctrl+A.
  2. In excel main menu, click Edit, then select Copy. Shortcuts: Ctrl+C.
  3. In excel main menu, click Edit, then select Paste. Shortcuts: Ctrl+V or press Enter button.
Note: this tip works well in excel 2003 (not support Excel 2007, 2010, 2013). This tip only remove hyperlinks, not remove formatting, formulas or others.

How To Remove Multiple Hyperlinks In Excel 2007, 2010, 2013

  1. Select the range containing hyperlinks that you want to remove.
  2. Click Home, move to Editing group and click the down arrow next to the Clear button.
  3. Choose Remove Hyperlinks. See screenshot:
    How To Remove Multiple Hyperlinks
  4. if you want to only clear the hyperlinks but not remove the formatting, choose Clear Hyperlinks.

or:

  1. Select the range containing hyperlinks that you want to remove.
  2. Press Right Button of mouse.
  3. Choose Remove Hyperlinks. See screenshot:
    How To Remove Multiple Hyperlinks

What's the difference between Clear Hyperlinks and Remove Hyperlinks?

Clear Hyperlinks
Clear the hyperlinks from the selected cells. The formatting is not cleared.
Remove Hyperlinks
Remove the hyperlinks and formatting from the selected cells.

How To Remove All Hyperlinks With VBA

  1. Press Alt+F11 to start the Visual Basic Editor.
  2. Double click the workbook you are using on the Project Explorer and type the following code:
    Sub RemoveAllHyperlinks()
        ActiveSheet.Hyperlinks.Delete
    End Sub

    If you want to remove selected multiple hyperlinks using VBA, copy this code:

    Sub RemoveSelectedHyperlinks()
        Selection.Hyperlinks.Delete
    End Sub
  3. Save your work.
  4. Run the macro by pressing Alt+F8 or using the menu by View -> Macros
  5. Select the macro you have made, it should have the name ‘RemoveAllHyperlinks’.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>

5 comments
  1. NS
    Nick Siso

    thanks for helping sir

  2. DU
    Durga

    I tried above code to remove hyperlink..its perfectly removed

    Thank You

More comments