Remove Hyperlinks in Excel


Remove a Single Excel Hyperlink

If you need to remove hyperlinks in excel, this is a simple process if you have only one or two hyperlinks. For each cell containing a hyperlink, simply right-click on the cell, using the mouse, and select the option Remove Hyperlink.

Although this is quick and simple for a small number of hyperlinks, it can be a slow and repetitive task if you have a large number of hyperlinks that you want to remove.


How to Remove Several Hyperlinks at Once

As there is no built-in Excel command to remove several hyperlinks at once, the Microsoft Office Website suggests the following workaround:

Use a Macro to Remove all Hyperlinks in Excel

Another way to quickly remove all hyperlinks in an Excel spreadsheet is to write a simple macro. The process for creating a macro to do this is described below:

' Code to Remove Hyperlinks in Excel

Sub RemoveAllHyperlinks()

ActiveSheet.Hyperlinks.Delete

End Sub

Visual Basic Editor Showing Code to Remove All Hyperlinks in Excel

Excel Window to Run the Remove All Hyperlinks Macro

To run this macro:



Return to the Basic Excel Page

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net