In this brief article, I will demonstrate how you can swiftly eliminate all unintended hyperlinks from an Excel worksheet all at once and stop them from appearing in the future. This method is effective across all Excel versions starting from Excel 2003 up to the latest Excel 2021 and the desktop version included in Microsoft 365.

Every time you input an email address or URL into a cell, Excel automatically transforms it into a clickable hyperlink. Based on my experience, this feature tends to be more of an annoyance than a help :-( Therefore, after typing a new email or editing a URL and pressing Enter, I typically press Ctrl Z to undo the hyperlink that Excel automatically generates...

First, I’ll explain how to delete all accidentally created unnecessary hyperlinks, and then I’ll show you how to configure Excel to disable the Auto-Hyperlinking feature.

In Excel 2000-2007, there is no built-in function to delete multiple hyperlinks simultaneously; you have to do it one by one. Here’s a simple trick that allows you to bypass this limitation, and this trick also works in Excel 2019, 2016, and 2013.

• Choose any empty cell outside your table.
• Enter 1 into this cell.
• Copy this cell (Ctrl C).
• Select your columns containing hyperlinks: click on any cell with data in the first column and press Ctrl Space to select the entire column:
• If you wish to select more than one column at a time: after selecting the first column, hold Ctrl, click on any cell in the second column, and press Space to select all cells in the second column without losing the selection in the first column.
• Right-click on any selected cells and choose "Paste Special" from the context menu:
• In the "Paste Special" dialog box, select the "Multiply" radio button in the "Operation" section:
• Click Ok. All hyperlinks are removed :-)

How to delete all hyperlinks in 2 clicks (Excel 2021 – 2010)

In Excel 2010, Microsoft finally introduced the capability to remove multiple hyperlinks at once:

• Select the entire column with hyperlinks: click on any cell with data and press Ctrl Space.

• Right-click on any selected cell and select "Remove hyperlinks" from the context menu. Note: If you select a single cell, this menu item changes to "Remove hyperlink," which is a good example of usability :-(

  

• All hyperlinks are removed from the column :-)

Disable automatic creation of hyperlinks in Excel

• In Excel 2007, click the Office button -> Excel Options. In Excel 2010 - 2019, go to the File Tab -> Options.
• In the "Excel Options" dialog box, switch to the "Proofing" tab in the left column and click the "AutoCorrect Options" button:
• In the "AutoCorrect Options" dialog box, switch to the "AutoFormat As You Type" tab and uncheck the "Internet and network paths with hyperlinks" checkbox.
• Click OK twice to close both dialogs and return to your Excel worksheet.

Now, when you type any URL or email into any cell, Excel retains the plain text format :-) If you need to create a hyperlink, simply press Ctrl K to open the "Insert Hyperlink" dialog box.

The above is the detailed content of How remove multiple hyperlinks from Excel worksheets at a time. For more information, please follow other related articles on the PHP Chinese website!