Removing hyperlinks in bulk

T

Terry Pinnell

A worksheet I prepared contains a lot of hyperlinks. (I pasted some
cells in from a web site.) I can see how to remove each one
individually with R-click > Hyperlink > Remove Hyperlink. But so far
haven't found a way to do it for an entire column, or the whole sheet.

Working with the sheet is awkward, as I often inadvertently open a
link in my browser when all I want to do is copy the text in that
cell.
 
E

Elkar

Select any blank cell and "Copy" it. Then select all of your hyperlinks that
you want to replace (or columns, or worksheet). Then select "Paste Special".
Under the "Operations" section, select "Add". That should do it.
 
I

i-Zapp

copy the range you just pasted, and paste it again to another location
(like another sheet) using "paste special, values".
 
T

Terry Pinnell

Elkar said:
Select any blank cell and "Copy" it. Then select all of your hyperlinks that
you want to replace (or columns, or worksheet). Then select "Paste Special".
Under the "Operations" section, select "Add". That should do it.
Click to expand...

Thanks. Looked neat, but didn't work!
 
T

Terry Pinnell

i-Zapp said:
copy the range you just pasted, and paste it again to another location
(like another sheet) using "paste special, values".
Click to expand...

Excellent, thanks. Seems to work a treat.
 
Top