Change a hyperlink

1. Right-click the hyperlink you want to change and click Edit Hyperlink on the shortcut menu.
2. 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.

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

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

1. Select the cell or graphic that represents the hyperlink.

   • To select a cell that contains a text hyperlink, click the cell and hold the mouse key down until the cursor changes to a cross .

   • To select a graphic, hold down CTRL and click the graphic.

2. Do one or more of the following:
   • To change text, edit the text in the formula bar.

   • To reformat a graphic, use the Drawing or Picture toolbar.

   • To change text that's part of a graphic, double-click the selected graphic and make the changes you want.

   • To change the graphic that represents the hyperlink, insert the new graphic and make it a hyperlink with the same destination. Then delete the old graphic or remove the hyperlink.