Remove All Hyperlinks Quickly in Excel

How to quickly remove all hyperlinks or a selection of hyperlinks from Excel.

This removes the link itself and any associated formatting but keeps the visible text in place.

Sections:

Remove Hyperlinks from Excel

Remove All Hyperlinks from a Worksheet at Once

Notes

Remove Hyperlinks from Excel

1. Select the cell that contains the hyperlink. Do this without navigating to the link by right-clicking the cell and then hitting the Esc (Escape) key to remove the menu that appears when you right-clicked the cell.
   
2. Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.
   
3. That's it!
   

Remove All Hyperlinks from a Worksheet at Once

1. Click the upper left corner of the spreadsheet to select the entire worksheet.
   
2. Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.
   
3. That's it!
   

Notes

This is a simple little trick that will save you a lot of time when you have to clean-up a worksheet.

Download the sample worksheet attached to this tutorial to try this out in Excel.