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.

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 a draft Excel spreadsheet, you might need to delete all notes and comments. You can delete every note and comment one by one, but this will take some time. This tip shows the quick way how to delete all notes and comments in your spreadsheet.
How to remove green triangles from cells (hide auto-calculating checks)

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

By default, when you work in Excel, 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.
How to select all the embedded charts on the worksheet

How to select all the embedded charts on the worksheet

If you need to select all objects embedded into the worksheet, e.g., select all charts to adjust their size, press Ctrl+G and click the Special button or use Ctrl to select objects individually.