Hyperlink formatting

[Clare1805]

Simple question - When you create a hyperlink in excel, it automatically makes the text blue with underlining - is there anyway to change this? I've looked everywhere but can't seem to find an answer!

 

[xlHammer]

Format Menu then click 'Style', select Hyperlink from the drop-down then click 'Modify' and away you go.

Rob

 

[Peter_SSs]

If you don't want to alter the 'Style', you can also use the Format Painter to paint the format from another cell (after you have ceated the Hyperlink)