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.


"Terry Pinnell" wrote:

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.

--
Terry, West Sussex, UK

"Elkar" wrote:

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.

Thanks. Looked neat, but didn't work!

--
Terry, West Sussex, UK