Originally Posted by
CC_mfc
Hi,
I am copy data from a website and pasting onto excel, what i need to do is to remove the hyperlinks as i can't click on a cell to edit without it launching the web page. when i do it individually and go into the formatting menu the 'remove hyperlink' option is there, however, when i highlight all the cells it only give me option to edit the hyperlink which would mean i can change them all i assume, but it still leaves me with the prob of having to remove the hyperlink for all cells.
Is there any way to do this? I have hundreds of these to do each month so it would be really useful if i could remove the hyperlink in bulk.
[Edit] or even if there is an option to just block all hyperlinks within a worksheet as i have no need for these.
thanks,
CC
Bookmarks