Removing hyperlinks in bulk

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
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.
 
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.
 
copy the range you just pasted, and paste it again to another location
(like another sheet) using "paste special, values".
 
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!
 
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.
 
I was trying tto remove hyperlink in bulk. I just looked into PCREVIEW and got the solution. I tried and just works. Thanks for simple steps, easy to follow solution.
 
Back
Top