Use macro command to bulk delete Excel document hyperlinks

In an Excel document, the program automatically turns it into a hyperlink when the content you enter in a cell includes a URL or an e-mail address. If you want to remove more hyperlinks, manual processing is obviously inefficient, you can use macro commands to bulk delete hyperlinks in Excel documents .

Press "Alt+f8" to open the Macro window, enter a name in the macro name, click Create, and then enter "Cells.Hyperlinks.Delete" between the sub and the End Sub, and then return to Excel after you save the macro you created. Open macros in the Macros submenu under the Tools menu, select the macro you just created in the open window, click Execute, and wait a moment to cancel all hyperlinks in the current table.