Delete all hyperlinks on a Excel worksheet

[ZexyZahid]

I was trying to look for an answer to this thread: http://www.planetcricket.org/forums/technology/football-scores-excel-70219.html

I bumped into another article, that I wanted to know as well. I just made this thread so you guys know how to do it. I just did it and it works.

Normally if you copy something with a lot of hyperlinks the size of your Excele file gets bigger. And it can really expand to over 1 MB, if you copy a lot of text with hyperlinks in it. Deleting unnecessary hyperlinks really lowers the size of the Excel file.

MS Excel: Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97
MS Excel: Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97

 

[Chewie]

Can't you just select the cells and go right click -> remove hyperlinks?

 

[ZexyZahid]

For multiple cells I don't see the option of removing hyperlinks. Otherwhile I wouldn't have created this thread. Maybe for versions above Excel 2003 it's different.

 

[Chewie]

Yea I have excel 2010 and I can ctrl+a and then right click and remove all hyperlinks