Hi allI have an excel sheet with loads of e-mail addresses and i DO NOT want them to be hyperlinked. I know you can hold down and right click and remove hyperlink. I just don't want hyperlinking on.I cant see in the menus where this option is to turn it off. From a very frustrated madboy
I don't know how to turn this feature off. However you can convert them. E.g with a hyperlink in B4=LEFT(B4,LEN(B4))and you could then copy this down as far as needed.
Go to tools>Auto Correct Options>Auto Format As you type "tab"Now untick the box that says "Internet and network paths with hyperlinks"Found it after 2 hoursThanks for your help VoG™
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.