Excel and Hyperlinking

  User-312386 17:28 25 Jan 05
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 05

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 05

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.

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos