Remove a hyperlink

Microsoft Office Excel 2003

  • To remove a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and click Clear Contents on the shortcut menu.
  • To remove a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.

ShowDeactivate a single hyperlink

  • Right-click the hyperlink you want to deactivate, and then click Remove Hyperlink on the shortcut menu.

ShowDeactivate several hyperlinks at once

  1. Type the number 1 in a blank cell, and right-click the cell.
  2. Click Copy on the shortcut menu.
  3. While pressing CTRL, select each hyperlink you want to deactivate.

    ShowHow?

    • To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross Excel selection cursor, then release the mouse button.
  4. Click Paste Special on the Edit menu.
  5. Under Operation, click Multiply and then click OK.