How to keep cell font setting after inserting hyperlink

Hi,

I have a problem with my MS Excel 2002 (actually it exists in MS Excel
97 too). Every time I'd associated a hyperlink with the text inside a
cell, the font will get change e.g. from Arial (size 10) to Arial (size
7). How can I instruct Excel to keep the original font setting without
change ?

Style, Hyperlink from your menu, uncheck fontsize
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"come_mon_come_mon!" <come_mon_come_mon@yahoo.com.hk> wrote in message news:1133155664.203986.48570@z14g2000cwz.googlegroups.com...
> Hi,
>
> I have a problem with my MS Excel 2002 (actually it exists in MS Excel
> 97 too). Every time I'd associated a hyperlink with the text inside a
> cell, the font will get change e.g. from Arial (size 10) to Arial (size
> 7). How can I instruct Excel to keep the original font setting without
> change ?
>
>
>

David McRitchie =E5=AF=AB=E9=81=93=EF=BC=9A

> Style, Hyperlink from your menu, uncheck fontsize

Can't find out your suggested menu option. I don't know whether you are
talking about Format->Cell Format option or Tools->Options tabs (I
guess not so). Anyway, no option found in my menu has your suggested
function.



> --
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>

Use the Format - Style menu.

This opens a dialog box. If you have added hyperlinks to the worksheet, you
should see two styles added to the drop-down; Hyperlink and Followed
Hyperlink.

Select each of these in turn and click Modify - set the fornt size to what
you require, then click ok.

Ed Ferrero
http://www.edferrero.com


"come_mon_come_mon!" <come_mon_come_mon@yahoo.com.hk> wrote in message
news:1133163410.003458.62240@g44g2000cwa.googlegroups.com...

David McRitchie ??:

> Style, Hyperlink from your menu, uncheck fontsize

Can't find out your suggested menu option. I don't know whether you are
talking about Format->Cell Format option or Tools->Options tabs (I
guess not so). Anyway, no option found in my menu has your suggested
function.



> --
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>

Ed Ferrero =E5=AF=AB=E9=81=93=EF=BC=9A

> Use the Format - Style menu.
>
> This opens a dialog box. If you have added hyperlinks to the worksheet, y=
ou
> should see two styles added to the drop-down; Hyperlink and Followed
> Hyperlink.
>
> Select each of these in turn and click Modify - set the fornt size to what
> you require, then click ok.
>
> Ed Ferrero
> http://www.edferrero.com
>

Oh! I found it. It seems work fine when I add hyperlink. But the font
size or style will change but not as I wish as I remove the hyperlink
by right clicking my mouse at the hyerlinked cell then choose to remove
hyperlink.

Hi Ed,
Thanks for the corrections, didn't realize you HAD to select a fontsize
under modify as opposed to letting it default. While fontsize is changed
immediately it appears that color is applied only to the selection range
or actually that everything in the selection range would be changed to
hyperlink style, whether it's a hyperlink or not.

Need a little work on understanding SCOPE of style changes and can't narrow
anything down in Google about style in Excel.

Besides "hyperlink" style there is also "followed hyperlink" style and that
seems to kick in once the hyperlink is selected during normal usage
of a hyperlink (it has it's own fontsize)..

Good grief, look at all of the newsgroups selected, any mistake in one
is made to 3 newsgroups.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ed Ferrero" <mail@edferrero.m6.net> wrote in message news:u6VESy$8FHA.1020@TK2MSFTNGP15.phx.gbl...
> Use the Format - Style menu.
>
> This opens a dialog box. If you have added hyperlinks to the worksheet, you
> should see two styles added to the drop-down; Hyperlink and Followed
> Hyperlink.
>
> Select each of these in turn and click Modify - set the fornt size to what
> you require, then click ok.
>
> Ed Ferrero
> http://www.edferrero.com
>
>
> "come_mon_come_mon!" <come_mon_come_mon@yahoo.com.hk> wrote in message
> news:1133163410.003458.62240@g44g2000cwa.googlegroups.com...
>
> David McRitchie ??:
>
> > Style, Hyperlink from your menu, uncheck fontsize
>
> Can't find out your suggested menu option. I don't know whether you are
> talking about Format->Cell Format option or Tools->Options tabs (I
> guess not so). Anyway, no option found in my menu has your suggested
> function.
>
>
>
> > --
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
>
>

David McRitchie =E5=AF=AB=E9=81=93=EF=BC=9A

> Hi Ed,
> Thanks for the corrections, didn't realize you HAD to select a fontsize
> under modify as opposed to letting it default. While fontsize is chang=
ed
> immediately it appears that color is applied only to the selection range
> or actually that everything in the selection range would be changed to
> hyperlink style, whether it's a hyperlink or not.
>
> Need a little work on understanding SCOPE of style changes and can't narr=
ow
> anything down in Google about style in Excel.
>
> Besides "hyperlink" style there is also "followed hyperlink" style=
and that
> seems to kick in once the hyperlink is selected during normal usage
> of a hyperlink (it has it's own fontsize)..
>
> Good grief, look at all of the newsgroups selected, any mistake in one
> is made to 3 newsgroups.
>
> ---

I found another side effect of making the change. Originally, those
cells with hyperlinks inserted will have their font color changed from
default black to blue and text underlined. I don't need to place the
mouse pointer explicitly over the cell to check whether the cell has
hyperlink attached. After I made the change, all text appeared black,
regardless of whether the cells had hyperlinks assigned. That made me
confused because I need check each cell separately to see if hyperlink
was assigned.