Discussion Locked

Excel 2000 email hyperlink removal

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
in excel if you type in an smtp address it automatically sticks it in as a hyperlink. How do you stop it automatically doing this. I know in Word you can switch it off but can see it in excel. I know that after they are in you can remove the hyperlink - but i don't want it there in the first place

6 replies

by tamj123

Just highlight the cell then right click on the mouse choose hypelink\remove hypelink

regard,

by s1m0nb

I stated in the question that I knew how to remove the link after it was in. I want to switch off the autoformating - thanx anyway

by delfeye

I avoid this by typing an apostrophe first in the cell where I am typing a hyperlink.

by s1m0nb

doesn't solve the problem of removing the autoformatting though - nice try though - if it was for me i'd agree but its for a user

by dfowler

Not sure if this will help, but there is a style option for hyperlinks that can be either disabled or turned off. It might be worth a try. Under Format on the top menu, and Style, you have the option of adding, deleting or modifying existing styles. found that if I chose the Hyperlink style off the dropdown and took the font checkmark off, it wouldn't underline and change the color of the text it wants to make a hyperlink. The drawback to this is that the text still works like a hyperlink if it is clicked on and that style change is only valid for that file.

I did basically the same thing for the hyperlink style, but did it through the Modify command on the style window and found that the change was effective (globally). The drawback is still that it works like a hyperlink if it is clicked on, it just doesn't look like a hyperlink.

The last option might be to delete the hyperlink style alltogether. There is a delete option on the style window, and I didnt' try this on mysystem because I use the hyperlinks, but it might be something else for yout to try. Hope this helps!!!

by s1m0nb

Again another worthy suggestion....but its the "acting like a hyperlink" that the user wants switched off - mad if you ask me but there you go. I've even tried saving the file as a excel 95 version which doesn't support the hyperlinks - which does convert them to plain text but as soon as you put another one in Excel 2000 converts it to a hyperlink - this is driving me a bit barmy - well no not really it has dropped to the bottom of my priority list

This discussion is closed to new replies.