How to use Excel macro features to bulk remove hyperlinks

Recently organized an Excel document, which has a lot of hyperlinks need to cancel the deletion, one cancellation is too time-consuming and laborious, so find a way to use the macro feature to remove hyperlinks in bulk.

① Use the Excel shortcut key Ctrl + F8, enter a name in the macro name of the pop-up Macro window, and then click the Create button;

At this point, a Microsoft Visual Basic window pops up;

② Enter Cells.Hyperlinks.Delete between the sub and End Sub, and then click the Save button to save it (you can save it anywhere);

③ back to the table just now, click "Tools" in the menu bar and select "Macros" in the down list.

④ Click the "Execute" button in the pop-up "Macros" window to bulk remove all hyperlinks in the Excel table.

See if all of the hyperlinks have been removed cleanly?