Change a hyperlink

ShowChange the destination of a hyperlink

  1. Right-click the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) 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 Excel selection cursor ), and then click the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) to edit the formula.

ShowChange the appearance of hyperlink text

When you make changes to the Hyperlink and Followed Hyperlink styles, your changes apply to all hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) 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.

ShowChange the text or graphic for a hyperlink

  1. Select the cell or graphic that represents the hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.).
    • 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 Excel selection cursor.
    • To select a graphic, hold down CTRL and click the graphic.
  2. Do one or more of the following:
 
 
Applies to:
Excel 2003