Easily Remove Hyperlinks in Excel

What could be easier than using Paste Special to remove your hyperlinks?

Here’s how:

1. In a blank cell in your worksheet, key in the number 1.
2. Select the cell and click CTRL + C to copy the cell contents to your Clipboard.
3. Depress your CTRL key as you click each hyperlink you would like to remove.
4. Display the Home tab of your Ribbon.
5. In the Clipboard group, click the down arrow under the Paste tool.
6. Select Paste Special to display the dialog box.

7. Select the Multiply button.
8. Click OK.

All of your hyperlinks have been removed but the text remains.

Delete the cell you created in step one above.