Menu

How do I stop automatic hyperlinks?

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Hank Scorpio

Posts: n/a

Default

On Fri, 4 Mar 2005 17:45:02 -0800, Jim in Berkeley <Jim in
wrote:

When I type an email address into a cell in Excel, it automatically becomes a
hyperlink and defaults to 10-point font. While that may be convenient at
times, I also want to prepare a list of email addresses that is NOT
hyperlinked. Even when I set the style for the column to be Normal instead of
Hyperlink, as soon as I type an email address it defaults to Hyperlink style.
How do I stop that?

In addition to Myrna's suggestions, you can stop them from appearing
in the first place by going to the following menu item:

Tools - Autocorrect Options... - Autoformat as you type (tab) -
uncheck "Internet and Network Paths with hyperlinks".

(This is in Excel XP; you haven't said which version you're using, so
I'm making a guess.)

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problems with hyperlinks	Lynde	Excel Discussion (Misc queries)	5	January 14th 05 08:39 PM
Can 2 different hyperlinks be in the same Excel cell?	rynes01	Excel Worksheet Functions	2	December 7th 04 05:15 PM
up-date hyperlinks in Excel	PM	Excel Worksheet Functions	0	November 11th 04 11:55 AM
How do I stop automatic page breaks in excel	Lesley Hutchinson	Excel Worksheet Functions	0	October 31st 04 12:49 PM
How do I stop other circles in other boxes to stop selecting?	stauff	Excel Worksheet Functions	1	October 28th 04 10:27 PM

All times are GMT +1. The time now is 09:56 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement