Remove a hyperlink

ShowDelete a hyperlink and the text or graphic that represents it

ShowDeactivate a single hyperlink

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 (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.) you want to deactivate.

ShowHow?

  1. Click Paste Special on the Edit menu.
  2. Under Operation, click Multiply and then click OK.
 
 
Applies to:
Excel 2003