How to remove all hyperlinks in your Excel spreadsheet

Excel 2016
By default, Excel automatically creates hyperlinks when you type or insert URLs or e-mails. You can Turn off the automatic creation of hyperlinks in Excel, or delete all hyperlinks later.

To delete all hyperlinks in your Excel sheet, do the following:

   1.   Select all cells in your Excel sheet where you want to delete hyperlinks.

To select all cells in the sheet, click Ctrl+A (see also Quick way to select all cells for more details).

   2.   Right-click on any selected cell and choose Remove Hyperlinks in the popup menu:

Remove hyperlinks in Excel 365

See also this tip in French: Comment supprimer tous les hyperliens de votre feuille de calcul Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.