Two ways to bulk delete a hyperlink in Excel 2007

In Excel, a column cell contains hyperlinks, and you have to remove hyperlinks by hand: Right-click any cell in the column that contains the hyperlink, and select Cancel hyperlink (Figure 1). As a result of the large number, we can only consider the use of bulk deletion method.

One, the macro code removal method

Open the Excel file, switch to the "View" tab, click "Macros" → "Record Macro", the "Record New Macro" window, the "macro name" to define a name: Removehyperlinks (Figure 2), click "OK" exit;

Click "Macros" → "View Macros", select "Removehyperlinks" under "Macro name" and click "Edit", open the Microsoft Visual Basic Editor, replace all the code in the right window with the following (Figure 3), and then save the VBA editor close:

Sub RemoveHyperlinks()
‘Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

Click "Macros" → "View Macros", select "Removehyperlinks" under "Macro name" and click "Execute" to remove the link from the sheet.

The same purpose can be achieved with the following code:

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub

Second, the selective pasting method

Right-click the column that contains the hyperlink and select Copy, then insert a blank column to the right of the column (left), and then right-click the blank column and select Paste selective (Figure 4).

In the Paste Selective window that appears later, click the value option (the attentive person will find that when you select options such as value, the Paste Link button becomes grayed out, and in Figure 5, the hyperlink is naturally not pasted, and the column is retained, and the column that originally contains the hyperlink is deleted.