How does Excel cancel an automatic hyperlink Excel connection Cancel

Excel Cancel Automatic hyperlink method one: Ctrl + Z Restore

If we enter Http://www.111cn.net now will automatically connect, then we just press CTRL + Z to remove the connection.

Excel Cancel Automatic Hyperlink Method Two: Automatic correction method

Click the Office button in the upper-left corner →excel options → proofing → autocorrect options → "AutoFormat As You Type" → uncheck "internet and network paths replaced by hyperlinks"

If it is a bulk link we cancel the method is a bit different, we use the automatic correction method to deal with the bulk connection

Paste Selective

Select all cells that you want to remove the hyperlink from;

Click the right mouse button and select Copy.

Select any blank cell, click the right mouse button, and select Paste selective.

In the pop-up dialog box, select "Value", click "OK";

Then the original with a hyperlink to delete the cell is OK; If the amount of data is too large to remove too much trouble, you can create a new workbook, copy the content directly "selectively paste" to a new workbook, and then save it;