Change a hyperlink

You can change an existing hyperlink in your workbook by changing its destination, its appearance, or the text or graphic that is used to represent it.What do you want to do?

Change the destination of a hyperlink

Change the appearance of hyperlink text

Change the text or graphic for a hyperlink

Change the destination of a hyperlink

1. Select the cell or graphic that contains the hyperlink that you want to change.

   Tip To select a cell that contains a hyperlink without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross , and then release the mouse button. You can also use the arrow keys to select the cell. To select a graphic, hold down CTRL and click the graphic.

2. On the Insert tab, in the Links group, click Hyperlink.

   

   Tip You can also right-click the cell or graphic and then click Edit Hyperlink on the shortcut menu, or you can press CTRL+K.

3. In the Edit Hyperlink dialog box, make the changes that 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 that contains the hyperlink, and then click the formula bar to edit the formula.

Change the appearance of hyperlink text

You can change the appearance of all hyperlink text in the current workbook by changing the cell style for hyperlinks.

1. On the Home tab, in the Styles group, click Cell Styles.

   

2. Under Data and Model, do the following:
   • To change the appearance of hyperlinks that have not been clicked to go to their destinations, right-click Hyperlink, and then click Modify.
   • To change the appearance of hyperlinks that have been clicked to go to their destinations, right-click Followed Hyperlink, and then click Modify.

   Note The Hyperlink cell style is available only when the workbook contains a hyperlink. The Followed Hyperlink cell style is available only when the workbook contains a hyperlink that has been clicked.

3. In the Style dialog box, click Format.
4. On the Font tab and Fill tab, select the formatting options that you want, and then click OK.

Notes:

• The options that you select in the Format Cells dialog box appear as selected 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 that you make to the Hyperlink and Followed Hyperlink cell styles apply to all hyperlinks in the current workbook. You cannot change the appearance of individual hyperlinks.

Change the text or graphic for a hyperlink

1. Select the cell or graphic that contains the hyperlink that you want to change.

   Tip To select a cell that contains a hyperlink without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross , and then release the mouse button. You can also use the arrow keys to select the cell. To select a graphic, hold down CTRL and click the graphic.

2. Do one or more of the following:
   • To change the hyperlink text, click in the formula bar, and then edit the text.
   • To change the format of a graphic, right-click it, and then click the option that you need to change its format.
   • To change text in a graphic, double-click the selected graphic, and then make the changes that you want.
   • To change the graphic that represents the hyperlink, insert a new graphic, make it a hyperlink with the same destination, and then delete the old graphic and hyperlink.

See also:

• Copy or move a hyperlink
• Create or remove a hyperlink
• Select a hyperlink without activating the link