Hyperlinks use memory, and lots of hyperlinks in your spreadsheet, document, or email can slow down your system, crash an open file, or even refuse to open the file. Use these handy tricks to keep them under control.

Delete multiple hyperlinks simultaneously

For example, no one has the time or desire to remove dozens of hyperlinks in a single spreadsheet, one at a time. While it’s a two-step process in Word and Outlook (Ctrl+A to select the entire document, then Ctrl+Shift+F9 to make them all disappear on every single page), Excel requires four steps.

First, choose a spreadsheet with multiple hyperlinks, or enter some email addresses and URLs in cells A2 through A12.

Highlight the column of hyperlinks.
Hold down the Ctrl key, then click any cell....

http://www.digitalclique.com.ng/excel-3-power-tips-to-moderate-hyperlinks/