How do I stop email addresses from changing color, size?
 

When I'm entering an email address into a cell in Excel, it changes the size
of the font and the color? How do I stop this from happening.

How do I stop email addresses from changing color, size?
 

Click TOOLS in the menu and select AUTOCORRECT.
Click the AUTOCORRECT AS YOU TYPE tab and turn off INTERNET AND NETWORK
PATHS AS YOU TYPE.
--
Kevin Backmann


"Tomatolover" wrote:

When I'm entering an email address into a cell in Excel, it changes the size
of the font and the color? How do I stop this from happening.

How do I stop email addresses from changing color, size?
 

If this is something you do just once in awhile rather than several
times in a given workbook, you might also consider the following.

When you type an email address or a URL into a cell, 2 actions
actually take place even though it appears as just 1. (1) Your entry
is accepted as text when you hit Enter, and (2) Excel then immediately
transforms your entry to a hyperlink. Since the Undo function undoes
the last action, simply do Ctrl+Z (or EditUndo) and that last action
of Excel transforming your text to a hyperlink will be undone, and
your entry will return to being just text.

How do I stop email addresses from changing color, size?
 

One more option...

Instead of removing the hyperlink from the cell (edit|Undo or ctrl-z, or by
changing that tools|Options|autocorrect options...), you could also change the
style for hyperlinks to what you want.

Format|Style|Select Hyperlink
change the formatting to what you want.

These styles live in workbooks, so you'd have to change the style for each
workbook that you use.

But the cells will still contain hyperlinks.

Tomatolover wrote:

When I'm entering an email address into a cell in Excel, it changes the size
of the font and the color? How do I stop this from happening.

--

Dave Peterson