Strange formatting when you enter an email address

  • Thread starter Thread starter Allan Savage
  • Start date Start date
A

Allan Savage

In Excel2000 (and maybe earlier versions), if I enter an
email address into a cell that is formatted for 12pt
text, after hitting the Enter ket the font size suddenly
changes to 5pt -- nigh unreadable. Doesn't happen in
Excel2002. Can anyone help??
 
It changed for me in xl2002 (from 12 to 10).

But I think it's getting the font size from the Hyperlink style.

Format|Style...
Hyperlink
click modify
Font tab
adjust the size to what you like.

Try it out.

If you change this style, then any cell that has hyperlink style will change as
soon as you hit ok.

And styles are kept in each workbook. So changing one workbook won't fix any
others.

(But it's a pretty neat way of changing a bunch of cells all at once, huh?)
 
But you could fix the hyperlink style in your book.xlt (a template workbook kept
in your XLStart folder), then every new workbook will inherit this setting from
this workbook template.
 
Back
Top