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 2016

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.