Email format changing when moving to next cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kat - 02 Apr 2007 22:17 GMT

I have an excel spreadsheet I created for when we get a new customer. The
user opens the protected sheet and enters info by tabbing from cell to cell.
I have changed the format of the email address cell to be Arial Narrow and
bold, when I enter info and tab or enter out of that field the formatting
changes to Arial and unbolded. How can I keep the format I want instead of
what excel wants to default to?

Thanks for the help!

Kat in WI

Reply to this Message

anon - 02 Apr 2007 22:52 GMT

>I have an excel spreadsheet I created for when we get a new customer. The
>user opens the protected sheet and enters info by tabbing from cell to cell.
>I have changed the format of the email address cell to be Arial Narrow and
>bold, when I enter info and tab or enter out of that field the formatting
>changes to Arial and unbolded. How can I keep the format I want instead of
>what excel wants to default to?

Sounds like you have a Conditional Format set. Do you? If so, unset
it and it will allow the underlying format to remain after the user
leaves the cell.

If you don't have one, and want to take the chicken's way out, just
set one to be Arial Narrow and bold.

Jim

Reply to this Message

Gord Dibben - 02 Apr 2007 23:23 GMT

Kat

When entering email addresses, Excel generally defaults to blue underlined
standard font to show hyperlinks.

Go to Tools>Autocorrect options>Autoformat as you type and uncheck the "internet
and network paths with hyperlinks"

Gord Dibben MS Excel MVP

>>I have an excel spreadsheet I created for when we get a new customer. The
>>user opens the protected sheet and enters info by tabbing from cell to cell.
[quoted text clipped - 11 lines]
>
>Jim

Reply to this Message

Rate this thread: