Select the range/column?? Have you tested this?

"Remove hyperlink" seems to work with one cell at a time only. What
dialogue? Clicking hyperlink = insert. Did I miss anything?

So far, only copy 1 and paste special (multiply) appears to remove
**multiple** hyperlinks.

Epinn

"SteveW" wrote in message
news:op.tep36tcoevjsnp@enigma03...
Sorry, I normally really check my posts in excel.
It removed the formatting, so *wrongly* I assumed it had removed the
hyperlink

Ta, for pointing it out.

Just select the range/column and right-click choose Hyperlink.. and then
*Remove Link..* from the dialogue

Steve

On Wed, 23 Aug 2006 04:47:15 +0100, Epinn
wrote:

Steve,

I followed your instructions. The format painter removed the underline
but
when I clicked on the cell, the link was still there. Am I missing
something?

Epinn

"SteveW" wrote in message
news:op.tepvvlgbevjsnp@enigma03...
Right-click and select hyperlink... and remove the link
Now using Format Painter copy this format to any other cell required.

Steve

On Wed, 23 Aug 2006 01:22:14 +0100, ilyaz wrote:

I have several columns with several dozens of hyperlinked entries in
each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still
were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.