Font enlarges when cell is linked to email

[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

 

[Gord Dibben]

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

 

[Dave Peterson]

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

 

[Gord Dibben]

Thanks Dave

If I ever knew that about the hyperlink style, I certainly forgot.


Gord

 

[Michael Lanier]

Thanks for the information. It works.

Michael

 

[Dave Peterson]

There are lots of things to remember. It's nice to have someone remember
ShellNew, too! <vbg>

 

[Gord Dibben]

Yup.

I guess we all have some tricks we picked up.


Gord