|Subject:||Removing hyperlinks from a whole column|
|Posted by:||Craig Thomson (firstname.lastname@example.org)|
|Date:||Tue, 28 Oct 2003|
I have recently cut and paste a table from a web page into a
spreadsheet. Unfortunately it has also copied in the link information
as well. This drives me nuts, as whenever I click on the cell my
browser opens. I have no need for the link so want to get rid of it.
I can remove the link on an individual cell by right-clicking and
selecting Hyperlink->Remove Hyperlink. However I cannot find a way to
do this for the entire column at once.
Thanks for any suggestions.