Excel and Hyperlinking

  User-312386 17:28 25 Jan 2005
Locked

Hi all

I 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

  VoG II 17:45 25 Jan 2005

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.

  User-312386 20:25 25 Jan 2005

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 hours

Thanks for your help VoG™

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review

How to draw a mandala

iPhone X review

Les meilleures enceintes Bluetooth à moins de 150 euros