Microsoft Office 2016: The Complete Guide (2015)
HOW TO CHANGE OR FORMAT A HYPERLINK
After you have created a hyperlink in your workbook, you can change the way it looks, where it leads to or the text or graphic representing it.
How to Change the destination of a hyperlink?
Choose the e cell or graphic that contains the hyperlink that you want to change.
TIP Select the cell where the hyperlink is and press the mouse icon. Hold it until turns into a symbol resembling a cross and then release it. Select the cell with the hyperlink using the arrow keys. A hyperlink that is in the form of a graphic can be selected by holding down the Ctrl key and selecting the graphic.
Then choose one of the following:
Go to the Insert tab, and under the Links group, select Hyperlink.
It is important to note that the formula must be changed in orders change the destination of a hyperlink if it was created with the HYPERLINK function with the hyperlink and go to the formula bar to make the edits
Right-click the cell or graphic, and then click Hyperlink, or you can press Ctrl+K.
How to change the appearance of hyperlink text?
You can change how the hyperlink text looks in your existing workbook by altering the cell style for hyperlinks.
Go to the Home tab, then select Styles group and then chose the option Cell Styles.
Select the option Data and Model, then choose one of the following options:
The appearance of non-clicked hyperlinks can be changed by right-clicking on Hyperlink, and then selecting Modify.
The appearance of clicked hyperlinks can be changed by right-clicking on The Followed Hyperlink, and then selecting Modify.
It should be noted that the workbook must contain at least one hyperlink for the Hyperlink cell style is to appear and it should also contain at least one clicked hyperlink for the Followed Hyperlink cell style to appear.
Go to the Style dialog box and select Format.
Choose the desired formatting by going to both the Font tab and Fill tab, and then select OK.
The options that you select in the Format Cells dialog box appear under Style includes in the Style dialog box. You can clear the check boxes for any options that you don't want to apply.
Changes cannot be applied to individual hyperlinks, any changes that have been made to the Hyperlink cell style and Followed Hyperlink cell style applies to all hyperlinks in the workbook.
How to change the text or graphic for a hyperlink?
Highlight the cell or image that has the hyperlink that you want to alter.
TIP- Select the cell where the hyperlink is and press the mouse icon. Hold it until turns into a symbol resembling a cross and then release it. Select the area that has the hyperlink using the arrow keys. A hyperlink that is in the form of a graphic can be selected by holding down the Ctrl key and selecting the graphic.
Then follow one of the following steps:
Go to the formula bar and select edit to change the hyperlink text.
To change the presentation of a graphic, right-click it, and then select the format choices that you want to change.
If you want to change a text within a graphic double-click on the image and you will be able to make the necessary changes.
If you want to replace the image representing the hyperlink, simply insert a new image and follow the steps to make it a hyperlink, then remove the old image and the hyperlink.