Removing multiple hyperlinks in Excel

Posted by & filed under Other.

There are some techniques on the web on how to remove all hyperlinks from Excel document. These include removing using Paste special and a macro. Sometimes it is difficult to use Paste special because of merged cells, and macro sounds too frightening and also it may spoil your formatting.

Another technique is to use Find and Replace.

  • Hit Ctrl+H
  • Click Options
  • For the field Find what, click the arrow on the button Format
  • Select option Choose Format From Cell
  • Pick the format of a cell with hyperlink
  • In the field Replace with, choose the format for a number without hyperlink
  • If you want to remove hyperlinks in the whole workbook, change Within from Sheet to Workbook.
  • Click Replace All