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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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 Edit>Undo) and that last action
of Excel transforming your text to a hyperlink will be undone, and
your entry will return to being just text.
 
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.
 
Back
Top