Font enlarges when cell is linked to email

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

Michael Lanier

When I enter an email, the font enlarges from 8 to 10 and underlines
itself. I can live with the auto underline if I must, but I need to
find a way to prevent the change of font size. Are there any
remedies? Thanks for your help.

Michael
 
In the AutoCorrect>Autoformat as you type turn off "internet and network
path etc."

I have never found a way to prevent the hyperlink from defaulting to 10
point font.


Gord Dibben MS Excel MVP
 
When excel turns the entry into a hyperlink, it applies the hyperlink style.

You can change this style to show whatever you like.

In xl2003 menus:
Format|style...
Select Hyperlink and click the modify button.
Change what you like.

Be aware that styles live in workbooks. You'll have to do it for every workbook
you need this in.

But you could create a template workbook that will be used for new workbooks.

Saved from a previous post:

You could create a workbook template named book.xlt and store it in your XLStart
folder. You can name the sheets whatever you want (and do other stuff, too --
print headers/footers/margins).

In xl2003, a new workbook will be created based on this workbook when you click
 
There are lots of things to remember. It's nice to have someone remember
ShellNew, too! <vbg>
 
Back
Top