Excel tables sometimes have hyperlinks, no use of their hyperlinks is annoying, only a few hyperlinks to say, but if you encounter such a large area of hyperlinks how to do? This article will teach you how to remove hyperlinks in Excel tables in bulk.
The way to unlink hyperlinks in an Excel table is simple, so just click the link and then select "Cancel HYPERLINK" in the pop-up menu. But if there are a lot of hyperlinks in the table, how do we cancel them? If one of the manual to cancel that would be a waste of time, what is the best way to remove all of these hyperlinks at once? Here blue1000 tell you a good way to use "macros" to remove hyperlinks in bulk.
How Excel Bulk Cancels hyperlinks
① Click the Tools button in the menu bar and select macros--> macros
② in the macro name in the Pop-up Macro window, type Bulk unlink hyperlink and click Create button.
③ will now enter the Excel module interface:
1. Enter the code between "sub bulk Cancel Hyperlink ()" and "End Sub": "Cells.Hyperlinks.Delete";
2, click the "Save" button to save it;
3, click "View Microsoft Excel" to return to the Excel interface;
④ when you return to the Excel interface, click the Tools--> macro--> macro in the menu bar, select the previously created bulk unlink macro in the window, and click the Execute button.
At this point, all the hyperlinks in the Excel table will be canceled.
Note that excel2003 is using the