e-mail addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna - 24 Feb 2008 23:58 GMT

While entering the membership information in my excel page, I entered the
person's e-mail address, sometimes it goes in the same color as the rest of
the document and other times it goes in BLUE. I would just like it to be all
the same color and not in blue. What can I do to change this from occurring?

Many thanks
Donna

Reply to this Message

Ed Hansberry, MS-MVP/Mobile Devices - 25 Feb 2008 01:37 GMT

>While entering the membership information in my excel page, I entered the
>person's e-mail address, sometimes it goes in the same color as the rest of
[quoted text clipped - 3 lines]
>Many thanks
>Donna

Excel is automatically making it a hyperlink. Clicking it will
open your email app pre-addressed to this person.

You can simply right-click it and select "Remove Hyperlink"

To remove multiple hyperlinks (note - just because you may
manually format it so it doesn't look like there is a hyperlink,
it may still be there), do the following;

Type a "1" in any cell (as long as it isn't formatted as text)
Copy
Select the hyperlink cells
Paste|Special|Multiply.

Signature

__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? - http://mvp.support.microsoft.com/

Reply to this Message

T. Valko - 25 Feb 2008 03:32 GMT

In addition, you can turn off the automatic hyperlinking:

In Excel 2002:

Tools>AutoCorrect Options>AutoFormat As You Type tab

Uncheck: Internet and network paths with hyperlinks

OK

Signature

Biff
Microsoft Excel MVP

>>While entering the membership information in my excel page, I entered the
>>person's e-mail address, sometimes it goes in the same color as the rest
[quoted text clipped - 20 lines]
> Select the hyperlink cells
> Paste|Special|Multiply.

Reply to this Message

Ed Hansberry, MS-MVP/Mobile Devices - 25 Feb 2008 11:17 GMT

>In addition, you can turn off the automatic hyperlinking:
>
[quoted text clipped - 5 lines]
>
>OK

Thanks. In 2007, that is Office Button, Excel Options, Proofing,
Auto-correct options, Autoformat as you type, then uncheck
"internet and network paths as hyperlinks.

Ok
Ok

Signature

Reply to this Message