Remove Hyperlinks from Excel
By Allen Wyatt for Excel.Tips.Net
Looking for a quick, easy way to remove hyperlinks without a macro? Believe it or not, you can accomplish this by using the Paste Special features of Excel. Follow these steps:
1. In a blank cell, enter the number 1.
2. Select the cell and press Ctrl+C. The cell content (1) is now copied to the Clipboard.
3. Hold down the Ctrl key as you click each hyperlink you want to remove.
4. Display the Home tab of the ribbon.
This post appears with permission from Allen Wyatt and Excel.Tips.Net.