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 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.
0 kommentar(er)
