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.

Paste Special

  1. Select the Multiply button.
  2. Click OK.

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

Delete the cell you created in step one above.


Scroll to Top


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!