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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?