Removing Hyperlinks without a Macro

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 Paste Special dialog box. (Click here to see a related figure.) (In versions of Excel before Excel 2007 choose Edit | Paste Special. In Excel 2007 display the Home tab of the ribbon, click the down-arrow under the Paste tool at the left of the ribbon, and then choose Paste Special.)
5. Select the Multiply radio button.
6. Click OK. All the hyperlinks are removed, but the text of the hyperlinks remain.
7. Delete the cell you created in step 1.