Remove Hyperlinks from Excel

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.

Steps continued here:

This post appears with permission from Allen Wyatt and Excel.Tips.Net.