Hyperlink - default font size and colour.

J

Johnnyboy5

I am using hyperlinks in a sheet in which I have set the font to 7 and
the text should all be black.

When I add a hyperlink in a cell (with someone’s name in it) the text
turns blue/underlined and size 10.

I would like it to be size 7 and black. Like the rest of the sheet.
The underline is OK so I know there is a link there.

Thanks

John
 
A

Alan

I am using hyperlinks in a sheet in which I have set the font to 7 and
the text should all be black.

When I add a hyperlink in a cell (with someone’s name in it)  the text
turns blue/underlined and size 10.

I would like it to be size 7 and black.  Like the rest of the sheet.
The underline is OK so I know there is a link there.

Thanks

John

From MS Excel Help ...

Change the appearance of hyperlink text

When you make changes to the Hyperlink and Followed Hyperlink styles,
your changes apply to all hyperlinks (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a
location in a file, a Web page on the World Wide Web, or a Web page on
an intranet. Hyperlinks can also go to newsgroups and to Gopher,
Telnet, and FTP sites.) in the current workbook.

1.On the Format menu, click Style.
2.To change the appearance of hyperlinks before or after they have
been clicked to make a jump, click Hyperlink or Followed Hyperlink in
the Style name box.
3.Click Modify.
4.Select the options you want, and then click OK.
5.Clear the check boxes for any options you don't want.
6.Click Add, and then click Close.
Note The Hyperlink style appears in the Style name box only if you
have previously created a text hyperlink in the workbook. The Followed
Hyperlink style appears only if you have used a text hyperlink in the
workbook to jump to another file and then returned to the original
workbook.

A.
 
J

Johnnyboy5

From MS Excel Help ...

Change the appearance of hyperlink text

When you make changes to the Hyperlink and Followed Hyperlink styles,
your changes apply to all hyperlinks (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a
location in a file, a Web page on the World Wide Web, or a Web page on
an intranet. Hyperlinks can also go to newsgroups and to Gopher,
Telnet, and FTP sites.) in the current workbook.

1.On the Format menu, click Style.
2.To change the appearance of hyperlinks before or after they have
been clicked to make a jump, click Hyperlink or Followed Hyperlink in
the Style name box.
3.Click Modify.
4.Select the options you want, and then click OK.
5.Clear the check boxes for any options you don't want.
6.Click Add, and then click Close.
 Note   The Hyperlink style appears in the Style name box only if you
have previously created a text hyperlink in the workbook. The Followed
Hyperlink style appears only if you have used a text hyperlink in the
workbook to jump to another file and then returned to the original
workbook.

A.

Thanks - does the job.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top