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

  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’.

Comments

  1. ET says

    I have tried clearing and remove hyperlinks as stated above (which I have done many times before) but I have a worksheet with two links that just won’t go! There is no protection on the worksheet, the ‘remove hyperlinks’ is greyed out so cannot be selected but the links are still there. I have tried overwriting them, deleting the cell(which it also won’t allow me to do), copying a different cell into it, replacing it with a different hyperlink but nothing work – please how do I get rid of these!

Leave a Reply

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