How to remove all hyperlinks in your Excel spreadsheet

Excel 365
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 2016

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.

How to delete all comments and notes in the spreadsheet

How to delete all comments and notes in the spreadsheet

When you create a presentation from your draft Excel spreadsheet, you might need to delete all comments. You can delete every comment one by one, but this will take some time. This tip shows the quick way how to delete all comments in your spreadsheet.
Turn off the automatic creation of hyperlinks in Excel

Turn off the automatic creation of hyperlinks in Excel

Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink such as URL or e-mail. You can quickly turn off and turn on the automatic creation of hyperlinks for more comfortable work in Excel ☺.
How to remove green triangles from cells (hide auto-calculating checks)

How to remove green triangles from cells (hide auto-calculating checks)

When you work in Excel, by default, it automatically identifies all issues, such as incorrect data in the cell, problems with formulas, etc. So, you see green triangles (by default) shown in the top left corner of these cells.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more