Hyperlink font format

[jimmisavage]

When i hyperling on excel the font automaticaly changes colour and underlines. Is there a way to stop this from happening?

Its not a big deal, but does annoy me a little.

Thanks

[sweep]

Hi,

From the help file

Change a hyperlink
Change the destination of a hyperlink

Right-click the hyperlink you want to change and click Edit Hyperlink on the shortcut menu.
Make the changes you want.
Note If the hyperlink was created by using the HYPERLINK worksheet function, you must edit the formula to change the destination. Select the cell with the hyperlink in it (click the cell and hold the mouse button until the cursor becomes a cross ), and then click the formula bar to edit the formula.

Change the appearance of hyperlink text

When you make changes to the Hyperlink and Followed Hyperlink styles, your changes apply to all hyperlinks in the current workbook.

On the Format menu, click Style.
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.
Click Modify.
Select the options you want, and then click OK.
Clear the check boxes for any options you don't want.
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.

Change the text or graphic for a hyperlink