remove all hyperlinks from a spreadsheet

[jimboryan]

Good morning,
I know if I want to remove a single hyperlink I can right-click and do it, but I have a spreadsheet with 52 tabs where each tab has a number of hyperlinks and I would like to remove them all. If I select an entire sheet I can't find a way to remove them all at once. Is it hidden somewhere, or does it not exist?

[davesexcel]

You should be able to select the entire sheet, right click and remove hyperlinks.

[jimboryan]

That option is only there if I click on a single hyperlink. If I select the whole sheet and then right click a hyperlink that option is not there.

[jimboryan]

I found a solution that worked for this.



Follow these steps:

In any empty cell, type in the number 1 (it can be deleted later).
Right click the cell where you typed the number 1 and then click on Copy.
Select the cells with hyperlinks that you want to delete.
On the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special.
Under Operation, click on Multiply, and then click OK.
On the Home tab, in the Styles group, click on Cell Styles. From the drop down menu, click on Normal.
Now the hyperlinks are deleted. You can now delete the number 1 used to perform this task.