We all know that if you enter a web address like www.microsoft.com, http://www.microsoft.com or even e mail address like admin@eforexcel.com, Excel converts these to Hyperlinks which can be clicked. Sometimes, we don't want this behaviour and we want to stop this –
Trick 1 – After entering a web address / e mail address, press CTRL+Z. The Hyperlink will get removed.
Trick 2 – Enter the web address / e mail address with a leading apostrophe
Trick 3 – File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type tab and uncheck "Internet and network paths with hyperlinks"
