To change the text of an existing hyperlink, you can right click on it, and edit the text in the formula bar. You can also right click the hyperlink, and select Edit Hyperlink from the drop down menu. This will display the Edit Hyperlink dialogue which is just like the Insert Hyperlink dialogue.

You can now change the target for the hyperlink, the screen tip, or the text to display. You can also remove the hyperlink from the worksheet, by clicking the Remove Link button. When you are finished with your modifications, click OK to implement them.

Note; remove hyperlink, and open hyperlink are also options on the drop down menu when you right click on a hyper link.

Hyperlinks will generally appear in one colour, (bright blue by default) before they have been clicked, and in another colour, (purple by default), after they have been clicked. You can change the font colour and size for an individual hyperlink by right clicking on it, and choosing format cells, from the drop down menu. This will display the format cells dialogue box, which you can use to modify the font colour, size, border, shading, and alignment of the link.

The format cells dialogue box.

The method just described will allow you to modify individual hyperlinks; but what about modifying the default colour and font size for all hyperlinks.

To change the default style for all hyperlinks, select Format->Style from the menu bar. This will display the style dialogue box.

Make sure that the word Hyperlink is selected in the drop list at the top of the Style box. You should be able to see a checkmark next to the word Font in the column of check boxes on the left. This means that the style for hyperlinks currently includes only font settings. Click the modify button to display the Format Cells dialogue box where you can make changes to the borders, shading, font size, font colour, and alignment for all un-followed hyperlinks. When you are finished modifying the hyperlink style, click the OK button in the format cells dialogue. You will now see The Style dialogue, with checkmarks corresponding to the style changes you have made. Click the OK button in the style box to implement the style changes.

Now every new hyperlink you create will have this new style by default.

To change the default style for followed links, select Format->style as before. In the Style name drop list, select Followed Hyperlink. Click OK to invoke the format cells dialogue box. The rest of the process is exactly similar to the preceding discussion.