Right click on anywhere within the selection and choose: Remove Hyperlinks.Now there are 2 options going forward to remove the links.Select all the cells, rows or columns (or simply the entire sheet with CTRL+A) that contains hyperlinks that you want to remove.The trick here is so easy, you might wonder how you could have ever overlooked it once you know it. Unfortunately, there is no option to globally disable hyperlinks in Excel or to have it function like in Word that you need to hold CTRL to follow a hyperlink.Īs discussed previously, there are a couple of alternative clicking and selection methods available to make it less likely that you activate a hyperlink but removing them all at once is luckily a possibility too. Is there any way to bulk remove or disable these clickable email addresses and turn them into regular text instead? In my current case, I’ve received an Excel sheet full of email addresses that are clickable mailto links which is highly annoying as sooner or later I’ll accidentally click on one. In the meantime, I am still waiting for additional remarks from the jury.In a previous tip you explained how to prevent email address in Excel turning into clickable mailto hyperlinks which is close to an issue I’m currently facing. I will be unable to obtain the requested information before Monday evening. I attempted to access his system Friday evening, after he had closed up shop for the day, but discovered that he had shut down his machine for the weekend. He commented to me that while the jury is still out, it would seem that the problem has healed itself with the updates. I discussed your note with my customer on Friday, intending on remotely accessing his machine to obtain the information you requested. I approved them early last week and they were installed over the course of the week. Last week I went back to check on the WSUS for the domain and discovered that there were more updates available that evidently were not previously installed. Many of the suggestions had already been tried.

(I installed all that were availableĪt the time.) The problem was observed and a solution was sought shortly after installation.

Following the installation, I downloaded and installed Office and Excel updates. Let me first explain that this was a new installation of Office 2007 (actually a reinstall after decommissioning another machine).

Stop creating hyperlinks in excel