Fonts for E-Mail Addresses

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

Whenever I type in excel, if I type an e-mail address, it
always goes to color blue, underlined and 5.5 font. I
typically want it to be black, bold and 13 font. How can
I change it to default to this? Thank you.
 
Hi Susan

In Excel 2002 you can turn it of

Tools>Auto correct Options
See the <AutoFormat as You Type> Tab

For older versions:
If you type in a E-mail address you can press Ctrl-Z after you
press enter to make it text

To make text from all your hyperlinks use a macro like this

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run
 
Back
Top