Tom’s Tutorials for Excel: Delete Hyperlinks, Keep Their Text
At some point you have probably inherited or created a worksheet that contains active hyperlinks, when all you want in the cells is the hyperlink text itself. It’s annoying to unwittingly click onto a hyperlink cell that interrupts your work by suddenly taking you away from your worksheet.
You could right-click on each hyperlink cell and select “Remove Hyperlink”. But if you have dozens or hundreds of hyperlinks on a worksheet as depicted in the above picture, you’ll need a faster and easier method, for example by following these 3 simple steps:
From your worksheet press
Alt+F11, which takes you to the Visual Basic Editor. From there, press
Ctrl+G to show the Immediate Window where your mouse cursor will be flashing.
As you see in the picture of the Immediate Window in the VBE, type the command
and press the
Exit the VBE by pressing
Alt+Q to return to your worksheet.